VIEW: APPS.MTL_ABC_COMPILES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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