Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_ABC_COMPILES_V |
SELECT A.ROWID
, A.COMPILE_ID
, B.COMPILE_NAME
, B.COMPILE_TYPE
, B.COMPILE_STATUS
, B.COMPILE_ITEMS
, B.COMPILE_DATE
, C.INVENTORY_ITEM_ID
, C.DESCRIPTION
, B.ITEM_SCOPE_CODE
, A.SEQUENCE_NUMBER
, A.COMPILE_QUANTITY
, A.COMPILE_VALUE
, A.CUMULATIVE_QUANTITY
, A.CUMULATIVE_VALUE
, DECODE(B.COMPILE_ITEMS
, 0
, 0
, A.SEQUENCE_NUMBER/B.COMPILE_ITEMS)
, DECODE(B.CUMULATIVE_VALUE
, 0
, 0
, A.COMPILE_VALUE/B.CUMULATIVE_VALUE)
, DECODE(B.CUMULATIVE_VALUE
, 0
, 0
, A.CUMULATIVE_VALUE/B.CUMULATIVE_VALUE)
, DECODE(B.COMPILE_ITEMS
, 0
, 0
, A.SEQUENCE_NUMBER/B.COMPILE_ITEMS)
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.ORGANIZATION_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.SECONDARY_INVENTORY
, A.INVENTORY_TYPE
, A.LAST_UPDATE_LOGIN
, B.DESCRIPTION
, B.COST_CODE
, B.COST_TYPE
, C.ATTRIBUTE_CATEGORY
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
FROM MTL_ABC_COMPILES A
, MTL_ABC_COMPILE_HEADERS B
, MTL_SYSTEM_ITEMS C
WHERE C.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
AND C.ORGANIZATION_ID = A.ORGANIZATION_ID
AND A.COMPILE_ID = B.COMPILE_ID