VIEW: APPS.DPP_XLA_INV_LINES_V

Source

View Text - Preformatted

SELECT dxi.event_id, ROW_NUMBER() OVER(Partition by EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER, (mmt.prior_cost-mmt.new_cost)*mmt.quantity_adjusted ENTERED_AMOUNT, (mmt.prior_cost-mmt.new_cost)*mmt.quantity_adjusted accounted_AMOUNT, GL.CURRENCY_CODE, MMT. SUBINVENTORY_CODE, MMT.LOCATOR_ID, MMT.COST_GROUP_ID, MMT.TRANSACTION_ID distribution_identifier, gl.ledger_id, MMT.TRANSACTION_ID, MMT.TRANSACTION_TYPE_ID, MMT.TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID, MMT.PRIMARY_QUANTITY, MMT.ORGANIZATION_ID, MMT.INVENTORY_ITEM_ID, MMT.TRANSACTION_DATE, MSI.COST_OF_SALES_ACCOUNT COGS_CCID, TRANSACTION_SUB_TYPE, MSI.SEGMENT1 ITEM_NUMBER, DTL.ATTRIBUTE_CATEGORY, DTL.ATTRIBUTE1 , DTL.ATTRIBUTE2 , DTL.ATTRIBUTE3 , DTL.ATTRIBUTE4 , DTL.ATTRIBUTE5 , DTL.ATTRIBUTE6 , DTL.ATTRIBUTE7 , DTL.ATTRIBUTE8 , DTL.ATTRIBUTE9 , DTL.ATTRIBUTE10 , DTL.ATTRIBUTE11 , DTL.ATTRIBUTE12 , DTL.ATTRIBUTE13 , DTL.ATTRIBUTE14 , DTL.ATTRIBUTE15 , DTL.ATTRIBUTE16 , DTL.ATTRIBUTE17 , DTL.ATTRIBUTE18 , DTL.ATTRIBUTE19 , DTL.ATTRIBUTE20 , DTL.ATTRIBUTE21 , DTL.ATTRIBUTE22 , DTL.ATTRIBUTE23 , DTL.ATTRIBUTE24 , DTL.ATTRIBUTE25 , DTL.ATTRIBUTE26 , DTL.ATTRIBUTE27 , DTL.ATTRIBUTE28 , DTL.ATTRIBUTE29 , DTL.ATTRIBUTE30 , DTL.SUPPLIER_PART_NUM , DTL.PRIOR_PRICE , DTL.CHANGE_TYPE , DTL.CHANGE_VALUE FROM MTL_MATERIAL_TRANSACTIONS MMT, DPP_XLA_INV_HEADERS_V DXI, GL_LEDGERS GL , DPP_XLA_LINES DXL, HR_OPERATING_UNITS HOU, MTL_SYSTEM_ITEMS_B MSI, DPP_TRANSACTION_HEADERS_ALL DTH, DPP_TRANSACTION_LINES_ALL DTL WHERE DXL.TRANSACTION_HEADER_ID=DXI.TRANSACTION_HEADER_ID AND MMT.TRANSACTION_ID = DXL.BASE_TRANSACTION_LINE_ID AND HOU.organization_id = DXI.ORG_ID AND HOU.set_of_books_id = GL.LEDGER_ID AND MSI.ORGANIZATION_ID=MMT.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID=MMT.INVENTORY_ITEM_ID AND DXL.BASE_TRANSACTION_HEADER_ID=DXI.BASE_TRANSACTION_HEADER_ID AND DTH.TRANSACTION_HEADER_ID=DXL.TRANSACTION_HEADER_ID AND DTL.TRANSACTION_HEADER_ID=DXL.TRANSACTION_HEADER_ID AND DTL.TRANSACTION_LINE_ID=DXL.TRANSACTION_LINE_ID

View Text - HTML Formatted

SELECT DXI.EVENT_ID
, ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY EVENT_ID) AS LINE_NUMBER
, (MMT.PRIOR_COST-MMT.NEW_COST)*MMT.QUANTITY_ADJUSTED ENTERED_AMOUNT
, (MMT.PRIOR_COST-MMT.NEW_COST)*MMT.QUANTITY_ADJUSTED ACCOUNTED_AMOUNT
, GL.CURRENCY_CODE
, MMT. SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MMT.COST_GROUP_ID
, MMT.TRANSACTION_ID DISTRIBUTION_IDENTIFIER
, GL.LEDGER_ID
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_TYPE_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID
, MMT.PRIMARY_QUANTITY
, MMT.ORGANIZATION_ID
, MMT.INVENTORY_ITEM_ID
, MMT.TRANSACTION_DATE
, MSI.COST_OF_SALES_ACCOUNT COGS_CCID
, TRANSACTION_SUB_TYPE
, MSI.SEGMENT1 ITEM_NUMBER
, DTL.ATTRIBUTE_CATEGORY
, DTL.ATTRIBUTE1
, DTL.ATTRIBUTE2
, DTL.ATTRIBUTE3
, DTL.ATTRIBUTE4
, DTL.ATTRIBUTE5
, DTL.ATTRIBUTE6
, DTL.ATTRIBUTE7
, DTL.ATTRIBUTE8
, DTL.ATTRIBUTE9
, DTL.ATTRIBUTE10
, DTL.ATTRIBUTE11
, DTL.ATTRIBUTE12
, DTL.ATTRIBUTE13
, DTL.ATTRIBUTE14
, DTL.ATTRIBUTE15
, DTL.ATTRIBUTE16
, DTL.ATTRIBUTE17
, DTL.ATTRIBUTE18
, DTL.ATTRIBUTE19
, DTL.ATTRIBUTE20
, DTL.ATTRIBUTE21
, DTL.ATTRIBUTE22
, DTL.ATTRIBUTE23
, DTL.ATTRIBUTE24
, DTL.ATTRIBUTE25
, DTL.ATTRIBUTE26
, DTL.ATTRIBUTE27
, DTL.ATTRIBUTE28
, DTL.ATTRIBUTE29
, DTL.ATTRIBUTE30
, DTL.SUPPLIER_PART_NUM
, DTL.PRIOR_PRICE
, DTL.CHANGE_TYPE
, DTL.CHANGE_VALUE
FROM MTL_MATERIAL_TRANSACTIONS MMT
, DPP_XLA_INV_HEADERS_V DXI
, GL_LEDGERS GL
, DPP_XLA_LINES DXL
, HR_OPERATING_UNITS HOU
, MTL_SYSTEM_ITEMS_B MSI
, DPP_TRANSACTION_HEADERS_ALL DTH
, DPP_TRANSACTION_LINES_ALL DTL
WHERE DXL.TRANSACTION_HEADER_ID=DXI.TRANSACTION_HEADER_ID
AND MMT.TRANSACTION_ID = DXL.BASE_TRANSACTION_LINE_ID
AND HOU.ORGANIZATION_ID = DXI.ORG_ID
AND HOU.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND MSI.ORGANIZATION_ID=MMT.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID=MMT.INVENTORY_ITEM_ID
AND DXL.BASE_TRANSACTION_HEADER_ID=DXI.BASE_TRANSACTION_HEADER_ID
AND DTH.TRANSACTION_HEADER_ID=DXL.TRANSACTION_HEADER_ID
AND DTL.TRANSACTION_HEADER_ID=DXL.TRANSACTION_HEADER_ID
AND DTL.TRANSACTION_LINE_ID=DXL.TRANSACTION_LINE_ID