Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVFV_SUBINVENTORIES |
SELECT MSS.SECONDARY_INVENTORY_NAME
, MSS.ORGANIZATION_ID
, MSS.DESCRIPTION
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MSS.DISABLE_DATE
, '_LA:MSS.INVENTORY_ATP_CODE:MFG_LOOKUPS:MTL_ATP_CODE:MEANING'
, '_LA:MSS.RESERVABLE_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MSS.LOCATOR_TYPE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING'
, MSS.PICKING_ORDER
, '_LA:MSS.QUANTITY_TRACKED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MSS.ASSET_INVENTORY:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MSS.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING'
, '_LA:MSS.AVAILABILITY_TYPE:MFG_LOOKUPS:MTL_AVAILABILITY:MEANING'
, MSS.PREPROCESSING_LEAD_TIME
, MSS.PROCESSING_LEAD_TIME
, MSS.POSTPROCESSING_LEAD_TIME
, MSS.MATERIAL_ACCOUNT
, '_KF:SQLGL:GL#:GLC1'
, MSS.MATERIAL_OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GLC2'
, MSS.RESOURCE_ACCOUNT
, '_KF:SQLGL:GL#:GLC3'
, MSS.OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GLC4'
, MSS.OUTSIDE_PROCESSING_ACCOUNT
, '_KF:SQLGL:GL#:GLC5'
, MSS.EXPENSE_ACCOUNT
, '_KF:SQLGL:GL#:GLC6'
, MSS.ENCUMBRANCE_ACCOUNT
, '_KF:SQLGL:GL#:GLC7'
, DECODE(MSS.SOURCE_TYPE
, 1
, MSS.SOURCE_ORGANIZATION_ID
, NULL)
, DECODE(MSS.SOURCE_TYPE
, 1
, MP2.ORGANIZATION_CODE
, NULL)
, DECODE(MSS.SOURCE_TYPE
, 1
, HOU2.NAME
, NULL)
, DECODE(MSS.SOURCE_TYPE
, 1
, MSS.SOURCE_SUBINVENTORY
, NULL)
, MSS.CREATED_BY
, MSS.CREATION_DATE
, MSS.LAST_UPDATED_BY
, MSS.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_CODE_COMBINATIONS GLC1
, GL_CODE_COMBINATIONS GLC2
, GL_CODE_COMBINATIONS GLC3
, GL_CODE_COMBINATIONS GLC4
, GL_CODE_COMBINATIONS GLC5
, GL_CODE_COMBINATIONS GLC6
, GL_CODE_COMBINATIONS GLC7
, MTL_SECONDARY_INVENTORIES MSS
WHERE GLC1.CODE_COMBINATION_ID (+) = MSS.MATERIAL_ACCOUNT AND GLC2.CODE_COMBINATION_ID (+) = MSS.MATERIAL_OVERHEAD_ACCOUNT AND GLC3.CODE_COMBINATION_ID (+) = MSS.RESOURCE_ACCOUNT AND GLC4.CODE_COMBINATION_ID (+) = MSS.OVERHEAD_ACCOUNT AND GLC5.CODE_COMBINATION_ID (+) = MSS.OUTSIDE_PROCESSING_ACCOUNT AND GLC6.CODE_COMBINATION_ID (+) = MSS.EXPENSE_ACCOUNT AND GLC7.CODE_COMBINATION_ID (+) = MSS.ENCUMBRANCE_ACCOUNT
AND MP1.ORGANIZATION_ID = MSS.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MSS.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MSS.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MSS.SOURCE_ORGANIZATION_ID
AND '_SEC:MSS.ORGANIZATION_ID' IS NOT NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) WITH READ ONLY