VIEW: APPS.CSP_ASL_ITEMS_V

Source

View Text - Preformatted

SELECT KFV.ROW_ID, KFV.INVENTORY_ITEM_ID, KFV.CONCATENATED_SEGMENTS, KFV.DESCRIPTION, KFV.ORGANIZATION_ID, OOD.ORGANIZATION_NAME, KFV.LAST_UPDATE_DATE, KFV.LAST_UPDATED_BY, KFV.CREATION_DATE, KFV.CREATED_BY,KFV.LAST_UPDATE_LOGIN, KFV.MIN_MINMAX_QUANTITY, KFV.MAX_MINMAX_QUANTITY, KFV.INVENTORY_PLANNING_CODE,KFV.FIXED_LOT_MULTIPLIER, KFV.MINIMUM_ORDER_QUANTITY, KFV.MAXIMUM_ORDER_QUANTITY, KFV.SOURCE_TYPE, DECODE(KFV.SOURCE_TYPE,1, 'Inventory',2, 'Vendor',3, 'Subinventory') SOURCE_TYPE_NAME, KFV.SOURCE_ORGANIZATION_ID, KFV.SOURCE_SUBINVENTORY,KFV.ENCUMBRANCE_ACCOUNT, KFV.PREPROCESSING_LEAD_TIME,KFV.POSTPROCESSING_LEAD_TIME, Nvl(CSL.MANUAL_AUTO,'NO'), CSL.REASON_CODE, FND.MEANING REASON_CODE_MEANING, KFV.ATTRIBUTE_CATEGORY, KFV.ATTRIBUTE1, KFV.ATTRIBUTE2, KFV.ATTRIBUTE3, KFV.ATTRIBUTE4, KFV.ATTRIBUTE5, KFV.ATTRIBUTE6, KFV.ATTRIBUTE7, KFV.ATTRIBUTE8, KFV.ATTRIBUTE9, KFV.ATTRIBUTE10, KFV.ATTRIBUTE11, KFV.ATTRIBUTE12, KFV.ATTRIBUTE13, KFV.ATTRIBUTE14, KFV.ATTRIBUTE15 From MTL_SYSTEM_ITEMS_B_KFV KFV, ORG_ORGANIZATION_DEFINITIONS OOD, CSP_STOCK_LISTS CSL, FND_LOOKUPS FND WHERE KFV.ORGANIZATION_ID = OOD.ORGANIZATION_ID AND KFV.INVENTORY_PLANNING_CODE = 2 AND KFV.INVENTORY_ITEM_ID = CSL.INVENTORY_ITEM_ID(+) AND KFV.ORGANIZATION_ID = CSL.ORGANIZATION_ID(+) AND CSL.REASON_CODE = FND.LOOKUP_CODE(+) AND FND.LOOKUP_TYPE(+) = 'CSP_ASL_REASON_CODE'

View Text - HTML Formatted

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