Query to Fetch Item Transaction Defaults in Oracle R12

Below Mentioned Query Will Fetch Item Transaction Defaults. For Filtering Based in Organization or Item Use the Highlighted Lines with suitable Values. 


SELECT MSIB.SEGMENT1 as ITEM,
  OOD.ORGANIZATION_CODE ,
  MLSS.Meaning as DEFAULT_FOR_SUB,
  MLSL.Meaning DEFAULT_FOR_SLOC,
  MISD.subinventory_code AS DEFAULT_SUB,
  MILD.subinventory_code AS DEFAULT_SUB_SLOC,
  MILK.CONCATENATED_SEGMENTS
FROM MTL_ITEM_LOC_DEFAULTS MILD,
  MTL_SYSTEM_ITEMS_B MSIB,
  ORG_ORGANIZATION_DEFINITIONS OOD,
  MTL_ITEM_SUB_DEFAULTS MISD,
  MFG_LOOKUPS MLSS,
  MFG_LOOKUPS MLSL,
  MTL_ITEM_LOCATIONS_KFV MILK
WHERE MILD.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
AND MISD.INVENTORY_ITEM_ID  = MSIB.INVENTORY_ITEM_ID
AND MILD.ORGANIZATION_ID     = MSIB.ORGANIZATION_ID
AND MISD.ORGANIZATION_ID     = MSIB.ORGANIZATION_ID
AND MILD.ORGANIZATION_ID     =MISD.ORGANIZATION_ID (+)
AND OOD.ORGANIZATION_ID      = MSIB.ORGANIZATION_ID
AND MILK.ORGANIZATION_ID     = MILD.ORGANIZATION_ID
AND MILD.SUBINVENTORY_CODE   = MISD.SUBINVENTORY_CODE(+)
AND MILD.DEFAULT_TYPE        = MLSL.Lookup_CODE
AND MISD.DEFAULT_TYPE        = MLSS.LOOKUP_CODE
and MILD.DEFAULT_TYPE        = MISD.DEFAULT_TYPE(+)
AND MLSS.LOOKUP_TYPE         = 'MTL_DEFAULT_SUBINVENTORY'
AND MLSL.LOOKUP_TYPE         = 'MTL_DEFAULT_LOCATORS'
--AND OOD.ORGANIZATION_CODE    = 'XXXXXX'
--AND MSIB.SEGMENT1           IN ('XXXX')

AND MILD.LOCATOR_ID        = MILK.INVENTORY_LOCATION_ID