View: CST_XLA_INV_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_INV_REF_V

View Text

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

Columns