VIEW: APPS.INVBV_SUBINVENTORIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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