eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CST_XLA_INV_REF_V

Source

View Text - Preformatted


SELECT MMT.TRANSACTION_ID , MMT.TRANSACTION_QUANTITY , MMT.TRANSACTION_UOM , MMT.TRANSACTION_SOURCE_ID , MMT.TRANSACTION_SOURCE_NAME , MMT.TRANSACTION_REFERENCE , MMT.REASON_ID , MMT.ENCUMBRANCE_AMOUNT , MMT.VARIANCE_AMOUNT PPV_VARIANCE_AMOUNT , MMT.DEPARTMENT_ID , MMT.OPERATION_SEQ_NUM , MMT.TRX_SOURCE_LINE_ID , MMT.PHYSICAL_ADJUSTMENT_ID , MMT.CYCLE_COUNT_ID , MMT.TRANSFER_TRANSACTION_ID , MMT.RCV_TRANSACTION_ID , MMT.MOVE_TRANSACTION_ID , MMT.COMPLETION_TRANSACTION_ID , MMT.SHIPMENT_NUMBER , MMT.TRANSFER_COST , MMT.TRANSPORTATION_COST , MMT.WAYBILL_AIRBILL , MMT.FREIGHT_CODE , MMT.ATTRIBUTE1 TRANSACTION_ATTRIBUTE1 , MMT.ATTRIBUTE2 TRANSACTION_ATTRIBUTE2 , MMT.ATTRIBUTE3 TRANSACTION_ATTRIBUTE3 , MMT.ATTRIBUTE4 TRANSACTION_ATTRIBUTE4 , MMT.ATTRIBUTE5 TRANSACTION_ATTRIBUTE5 , MMT.ATTRIBUTE6 TRANSACTION_ATTRIBUTE6 , MMT.ATTRIBUTE7 TRANSACTION_ATTRIBUTE7 , MMT.ATTRIBUTE8 TRANSACTION_ATTRIBUTE8 , MMT.ATTRIBUTE9 TRANSACTION_ATTRIBUTE9 , MMT.ATTRIBUTE10 TRANSACTION_ATTRIBUTE10 , MMT.ATTRIBUTE11 TRANSACTION_ATTRIBUTE11 , MMT.ATTRIBUTE12 TRANSACTION_ATTRIBUTE12 , MMT.ATTRIBUTE13 TRANSACTION_ATTRIBUTE13 , MMT.ATTRIBUTE14 TRANSACTION_ATTRIBUTE14 , MMT.ATTRIBUTE15 TRANSACTION_ATTRIBUTE15 , MMT.PA_EXPENDITURE_ORG_ID , MMT.EXPENDITURE_TYPE , NVL(MMT.FINAL_COMPLETION_FLAG,'N') FINAL_COMPLETION_FLAG, MMT.TRANSFER_PERCENTAGE , MMT.PICK_SLIP_NUMBER , MMT.FOB_POINT , MMT.PARENT_TRANSACTION_ID , MMT.LOGICAL_TRX_TYPE_CODE , DECODE(MMT.LOGICAL_TRANSACTION, 1, 'Y', 'N' ) LOGICAL_TRANSACTION , MMT.INTERCOMPANY_PRICING_OPTION , NVL(CCE.COGS_PERCENTAGE,0)- NVL(CCE.PRIOR_COGS_PERCENTAGE,0) COGS_RECOG_PERCENT_CHANGE, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID, 2, NVL(MMT.COGS_RECOGNITION_PERCENT, 100), NULL ) COGS_PERCENTAGE , -1*NVL(MTA.BASE_TRANSACTION_VALUE,0) ENCUMBRANCE_REVERSAL_AMOUNT , -1*NVL(MTA.TRANSACTION_VALUE,0) ENCUM_REVERSAL_AMOUNT_ENTERED, RT.SHIPMENT_HEADER_ID TXN_SHIPMENT_HEADER_ID , RT.SHIPMENT_LINE_ID TXN_SHIPMENT_LINE_ID , 201 APPLIED_TO_APPL_ID , DECODE(RT.PO_RELEASE_ID, NULL, 'PURCHASE_ORDER', 'RELEASE') APPLIED_TO_ENTITY_CODE , 'PO_DISTRIBUTIONS_ALL' APPLIED_TO_DIST_LINK_TYPE , RT.PO_HEADER_ID TXN_PO_HEADER_ID , RT.PO_DISTRIBUTION_ID TXN_PO_DISTRIBUTION_ID , 'REQUISITION' BUS_FLOW_REQ_ENTITY_CODE , 'PO_REQ_DISTRIBUTIONS_ALL' BUS_FLOW_REQ_DIST_TYPE , RT.REQ_DISTRIBUTION_ID BUS_FLOW_REQ_DIST_ID , PRLA.REQUISITION_HEADER_ID BUS_FLOW_REQ_ID , MMT.PERCENTAGE_CHANGE , MMT.VALUE_CHANGE , MMT.REPETITIVE_LINE_ID , NVL(RT.PO_RELEASE_ID, RT.PO_HEADER_ID) APPLIED_TO_PO_DOC_ID , MMT.DISTRIBUTION_ACCOUNT_ID INV_TXN_DISTRIBUTION_ACCT, MMT.TRANSPORTATION_DIST_ACCOUNT INV_TXN_TRANSPO_DIST_ACCT, MMT.EXPENSE_ACCOUNT_ID INV_TXN_EXPENSE_ACCT , MMT.MATERIAL_ACCOUNT INV_TXN_MATERIAL_ACCT , MMT.MATERIAL_OVERHEAD_ACCOUNT INV_TXN_MAT_OVHD_ACCT , MMT.OUTSIDE_PROCESSING_ACCOUNT INV_TXN_OUT_PROC_ACCT , MMT.OVERHEAD_ACCOUNT INV_TXN_OVERHEAD_ACCT , MMT.RESOURCE_ACCOUNT INV_TXN_RESOURCE_ACCT FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_ACCOUNTS MTA , CST_COGS_EVENTS CCE , RCV_TRANSACTIONS RT , PO_REQUISITION_LINES_ALL PRLA WHERE CCE.MMT_TRANSACTION_ID (+) = MMT.TRANSACTION_ID AND MTA.TRANSACTION_ID (+) = MMT.TRANSACTION_ID AND MTA.ACCOUNTING_LINE_TYPE (+) = 15 AND RT.TRANSACTION_ID (+) = MMT.RCV_TRANSACTION_ID AND PRLA.REQUISITION_LINE_ID (+) = RT.REQUISITION_LINE_ID

View Text - HTML Formatted

SELECT MMT.TRANSACTION_ID
, MMT.TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.TRANSACTION_SOURCE_ID
, MMT.TRANSACTION_SOURCE_NAME
, MMT.TRANSACTION_REFERENCE
, MMT.REASON_ID
, MMT.ENCUMBRANCE_AMOUNT
, MMT.VARIANCE_AMOUNT PPV_VARIANCE_AMOUNT
, MMT.DEPARTMENT_ID
, MMT.OPERATION_SEQ_NUM
, MMT.TRX_SOURCE_LINE_ID
, MMT.PHYSICAL_ADJUSTMENT_ID
, MMT.CYCLE_COUNT_ID
, MMT.TRANSFER_TRANSACTION_ID
, MMT.RCV_TRANSACTION_ID
, MMT.MOVE_TRANSACTION_ID
, MMT.COMPLETION_TRANSACTION_ID
, MMT.SHIPMENT_NUMBER
, MMT.TRANSFER_COST
, MMT.TRANSPORTATION_COST
, MMT.WAYBILL_AIRBILL
, MMT.FREIGHT_CODE
, MMT.ATTRIBUTE1 TRANSACTION_ATTRIBUTE1
, MMT.ATTRIBUTE2 TRANSACTION_ATTRIBUTE2
, MMT.ATTRIBUTE3 TRANSACTION_ATTRIBUTE3
, MMT.ATTRIBUTE4 TRANSACTION_ATTRIBUTE4
, MMT.ATTRIBUTE5 TRANSACTION_ATTRIBUTE5
, MMT.ATTRIBUTE6 TRANSACTION_ATTRIBUTE6
, MMT.ATTRIBUTE7 TRANSACTION_ATTRIBUTE7
, MMT.ATTRIBUTE8 TRANSACTION_ATTRIBUTE8
, MMT.ATTRIBUTE9 TRANSACTION_ATTRIBUTE9
, MMT.ATTRIBUTE10 TRANSACTION_ATTRIBUTE10
, MMT.ATTRIBUTE11 TRANSACTION_ATTRIBUTE11
, MMT.ATTRIBUTE12 TRANSACTION_ATTRIBUTE12
, MMT.ATTRIBUTE13 TRANSACTION_ATTRIBUTE13
, MMT.ATTRIBUTE14 TRANSACTION_ATTRIBUTE14
, MMT.ATTRIBUTE15 TRANSACTION_ATTRIBUTE15
, MMT.PA_EXPENDITURE_ORG_ID
, MMT.EXPENDITURE_TYPE
, NVL(MMT.FINAL_COMPLETION_FLAG
, 'N') FINAL_COMPLETION_FLAG
, MMT.TRANSFER_PERCENTAGE
, MMT.PICK_SLIP_NUMBER
, MMT.FOB_POINT
, MMT.PARENT_TRANSACTION_ID
, MMT.LOGICAL_TRX_TYPE_CODE
, DECODE(MMT.LOGICAL_TRANSACTION
, 1
, 'Y'
, 'N' ) LOGICAL_TRANSACTION
, MMT.INTERCOMPANY_PRICING_OPTION
, NVL(CCE.COGS_PERCENTAGE
, 0)- NVL(CCE.PRIOR_COGS_PERCENTAGE
, 0) COGS_RECOG_PERCENT_CHANGE
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 2
, NVL(MMT.COGS_RECOGNITION_PERCENT
, 100)
, NULL ) COGS_PERCENTAGE
, -1*NVL(MTA.BASE_TRANSACTION_VALUE
, 0) ENCUMBRANCE_REVERSAL_AMOUNT
, -1*NVL(MTA.TRANSACTION_VALUE
, 0) ENCUM_REVERSAL_AMOUNT_ENTERED
, RT.SHIPMENT_HEADER_ID TXN_SHIPMENT_HEADER_ID
, RT.SHIPMENT_LINE_ID TXN_SHIPMENT_LINE_ID
, 201 APPLIED_TO_APPL_ID
, DECODE(RT.PO_RELEASE_ID
, NULL
, 'PURCHASE_ORDER'
, 'RELEASE') APPLIED_TO_ENTITY_CODE
, 'PO_DISTRIBUTIONS_ALL' APPLIED_TO_DIST_LINK_TYPE
, RT.PO_HEADER_ID TXN_PO_HEADER_ID
, RT.PO_DISTRIBUTION_ID TXN_PO_DISTRIBUTION_ID
, 'REQUISITION' BUS_FLOW_REQ_ENTITY_CODE
, 'PO_REQ_DISTRIBUTIONS_ALL' BUS_FLOW_REQ_DIST_TYPE
, RT.REQ_DISTRIBUTION_ID BUS_FLOW_REQ_DIST_ID
, PRLA.REQUISITION_HEADER_ID BUS_FLOW_REQ_ID
, MMT.PERCENTAGE_CHANGE
, MMT.VALUE_CHANGE
, MMT.REPETITIVE_LINE_ID
, NVL(RT.PO_RELEASE_ID
, RT.PO_HEADER_ID) APPLIED_TO_PO_DOC_ID
, MMT.DISTRIBUTION_ACCOUNT_ID INV_TXN_DISTRIBUTION_ACCT
, MMT.TRANSPORTATION_DIST_ACCOUNT INV_TXN_TRANSPO_DIST_ACCT
, MMT.EXPENSE_ACCOUNT_ID INV_TXN_EXPENSE_ACCT
, MMT.MATERIAL_ACCOUNT INV_TXN_MATERIAL_ACCT
, MMT.MATERIAL_OVERHEAD_ACCOUNT INV_TXN_MAT_OVHD_ACCT
, MMT.OUTSIDE_PROCESSING_ACCOUNT INV_TXN_OUT_PROC_ACCT
, MMT.OVERHEAD_ACCOUNT INV_TXN_OVERHEAD_ACCT
, MMT.RESOURCE_ACCOUNT INV_TXN_RESOURCE_ACCT
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_ACCOUNTS MTA
, CST_COGS_EVENTS CCE
, RCV_TRANSACTIONS RT
, PO_REQUISITION_LINES_ALL PRLA
WHERE CCE.MMT_TRANSACTION_ID (+) = MMT.TRANSACTION_ID
AND MTA.TRANSACTION_ID (+) = MMT.TRANSACTION_ID
AND MTA.ACCOUNTING_LINE_TYPE (+) = 15
AND RT.TRANSACTION_ID (+) = MMT.RCV_TRANSACTION_ID
AND PRLA.REQUISITION_LINE_ID (+) = RT.REQUISITION_LINE_ID