Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_SUBINVENTORIES |
SELECT MSS.SECONDARY_INVENTORY_NAME
, MSS.ORGANIZATION_ID
, MSS.DESCRIPTION
, MSS.DISABLE_DATE
, '_LA:MSS.INVENTORY_ATP_CODE:MFG_LOOKUPS:MTL_ATP_CODE:MEANING'
, /* LOOKUP */ '_LA:MSS.RESERVABLE_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ '_LA:MSS.LOCATOR_TYPE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING'
, /* LOOKUP */ MSS.PICKING_ORDER
, '_LA:MSS.QUANTITY_TRACKED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ '_LA:MSS.ASSET_INVENTORY:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ '_LA:MSS.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING'
, /* LOOKUP */ '_LA:MSS.AVAILABILITY_TYPE:MFG_LOOKUPS:MTL_AVAILABILITY:MEANING'
, /* LOOKUP */ MSS.PREPROCESSING_LEAD_TIME
, MSS.PROCESSING_LEAD_TIME
, MSS.POSTPROCESSING_LEAD_TIME
, MSS.MATERIAL_ACCOUNT
, MSS.MATERIAL_OVERHEAD_ACCOUNT
, MSS.RESOURCE_ACCOUNT
, MSS.OVERHEAD_ACCOUNT
, MSS.OUTSIDE_PROCESSING_ACCOUNT
, MSS.EXPENSE_ACCOUNT
, MSS.ENCUMBRANCE_ACCOUNT
, DECODE (MSS.SOURCE_TYPE
, 1
, MSS.SOURCE_ORGANIZATION_ID
, 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_SECONDARY_INVENTORIES MSS
WHERE '_SEC:MSS.ORGANIZATION_ID' IS NOT NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) WITH READ ONLY