VIEW: APPS.CSP_ITEM_SUB_INVENTORIES_ALL_V

Source

View Text - Preformatted

SELECT MIS.ROW_ID, MIS.INVENTORY_ITEM_ID, KFV.CONCATENATED_SEGMENTS, MIS.ITEM_DESCRIPTION, MIS.ORGANIZATION_ID,OOD.ORGANIZATION_CODE,OOD.ORGANIZATION_NAME, MIS.SECONDARY_INVENTORY, MIS.SUB_DESCRIPTION, MIS.LAST_UPDATE_DATE, MIS.LAST_UPDATED_BY, MIS.CREATION_DATE, MIS.CREATED_BY, MIS.LAST_UPDATE_LOGIN, MIS.PRIMARY_SUBINVENTORY_FLAG, MIS.PICKING_ORDER, MIS.MIN_MINMAX_QUANTITY, MIS.MAX_MINMAX_QUANTITY, MIS.INVENTORY_PLANNING_CODE, MIS.FIXED_LOT_MULTIPLE, MIS.MINIMUM_ORDER_QUANTITY, MIS.MAXIMUM_ORDER_QUANTITY, MIS.SOURCE_TYPE, DECODE(MIS.SOURCE_TYPE,1,'Inventory',2,'Vendor',3,'Subinventory') SOURCE_TYPE_NAME, MIS.SOURCE_ORGANIZATION_ID, MIS.SOURCE_ORGANIZATION, MIS.SOURCE_ORG_NAME, MIS.SOURCE_SUBINVENTORY, MIS.ENCUMBRANCE_ACCOUNT, MIS.PREPROCESSING_LEAD_TIME, MIS.PROCESSING_LEAD_TIME, MIS.POSTPROCESSING_LEAD_TIME, NVL(CSL.MANUAL_AUTO,'NO'),CSL.REASON_CODE, FND.MEANING REASON_CODE_MEANING, MIS.ATTRIBUTE_CATEGORY, MIS.ATTRIBUTE1, MIS.ATTRIBUTE2, MIS.ATTRIBUTE3, MIS.ATTRIBUTE4, MIS.ATTRIBUTE5, MIS.ATTRIBUTE6, MIS.ATTRIBUTE7, MIS.ATTRIBUTE8, MIS.ATTRIBUTE9, MIS.ATTRIBUTE10, MIS.ATTRIBUTE11, MIS.ATTRIBUTE12, MIS.ATTRIBUTE13, MIS.ATTRIBUTE14, MIS.ATTRIBUTE15 from MTL_ITEM_SUB_INVENTORIES_ALL_V MIS, MTL_SYSTEM_ITEMS_B_KFV KFV, CSP_STOCK_LISTS CSL, ORG_ORGANIZATION_DEFINITIONS OOD,FND_LOOKUPS FND WHERE MIS.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID AND MIS.ORGANIZATION_ID = KFV.ORGANIZATION_ID AND MIS.INVENTORY_ITEM_ID = CSL.INVENTORY_ITEM_ID(+) AND MIS.ORGANIZATION_ID = CSL.ORGANIZATION_ID(+) AND MIS.SECONDARY_INVENTORY = CSL.SUBINVENTORY_CODE(+) AND MIS.ORGANIZATION_ID = OOD.ORGANIZATION_ID AND CSL.REASON_CODE = FND.LOOKUP_CODE(+) AND FND.LOOKUP_TYPE(+) = 'CSP_ASL_REASON_CODE'

View Text - HTML Formatted

SELECT MIS.ROW_ID
, MIS.INVENTORY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, MIS.ITEM_DESCRIPTION
, MIS.ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME
, MIS.SECONDARY_INVENTORY
, MIS.SUB_DESCRIPTION
, MIS.LAST_UPDATE_DATE
, MIS.LAST_UPDATED_BY
, MIS.CREATION_DATE
, MIS.CREATED_BY
, MIS.LAST_UPDATE_LOGIN
, MIS.PRIMARY_SUBINVENTORY_FLAG
, MIS.PICKING_ORDER
, MIS.MIN_MINMAX_QUANTITY
, MIS.MAX_MINMAX_QUANTITY
, MIS.INVENTORY_PLANNING_CODE
, MIS.FIXED_LOT_MULTIPLE
, MIS.MINIMUM_ORDER_QUANTITY
, MIS.MAXIMUM_ORDER_QUANTITY
, MIS.SOURCE_TYPE
, DECODE(MIS.SOURCE_TYPE
, 1
, 'INVENTORY'
, 2
, 'VENDOR'
, 3
, 'SUBINVENTORY') SOURCE_TYPE_NAME
, MIS.SOURCE_ORGANIZATION_ID
, MIS.SOURCE_ORGANIZATION
, MIS.SOURCE_ORG_NAME
, MIS.SOURCE_SUBINVENTORY
, MIS.ENCUMBRANCE_ACCOUNT
, MIS.PREPROCESSING_LEAD_TIME
, MIS.PROCESSING_LEAD_TIME
, MIS.POSTPROCESSING_LEAD_TIME
, NVL(CSL.MANUAL_AUTO
, 'NO')
, CSL.REASON_CODE
, FND.MEANING REASON_CODE_MEANING
, MIS.ATTRIBUTE_CATEGORY
, MIS.ATTRIBUTE1
, MIS.ATTRIBUTE2
, MIS.ATTRIBUTE3
, MIS.ATTRIBUTE4
, MIS.ATTRIBUTE5
, MIS.ATTRIBUTE6
, MIS.ATTRIBUTE7
, MIS.ATTRIBUTE8
, MIS.ATTRIBUTE9
, MIS.ATTRIBUTE10
, MIS.ATTRIBUTE11
, MIS.ATTRIBUTE12
, MIS.ATTRIBUTE13
, MIS.ATTRIBUTE14
, MIS.ATTRIBUTE15
FROM MTL_ITEM_SUB_INVENTORIES_ALL_V MIS
, MTL_SYSTEM_ITEMS_B_KFV KFV
, CSP_STOCK_LISTS CSL
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_LOOKUPS FND
WHERE MIS.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND MIS.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND MIS.INVENTORY_ITEM_ID = CSL.INVENTORY_ITEM_ID(+)
AND MIS.ORGANIZATION_ID = CSL.ORGANIZATION_ID(+)
AND MIS.SECONDARY_INVENTORY = CSL.SUBINVENTORY_CODE(+)
AND MIS.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND CSL.REASON_CODE = FND.LOOKUP_CODE(+)
AND FND.LOOKUP_TYPE(+) = 'CSP_ASL_REASON_CODE'