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.

[Home] [Help]

View: DPP_XLA_INV_LINES_V

Product:	DPP - Oracle Price Protection
Description:	Dpp SLA Cost Update Lines View
Implementation/DBA Data:	APPS.DPP_XLA_INV_LINES_V

View Text

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

Columns

Name
EVENT_ID
LINE_NUMBER
ENTERED_AMOUNT
ACCOUNTED_AMOUNT
CURRENCY_CODE
SUBINVENTORY_CODE
LOCATOR_ID
COST_GROUP_ID
DISTRIBUTION_IDENTIFIER
LEDGER_ID
TRANSACTION_ID
TRANSACTION_TYPE_ID
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_ACTION_ID
PRIMARY_QUANTITY
ORGANIZATION_ID
INVENTORY_ITEM_ID
TRANSACTION_DATE
COGS_CCID
TRANSACTION_SUB_TYPE
ITEM_NUMBER
LINE_ATTR_CATEGORY
LINE_ATTRIBUTE1
LINE_ATTRIBUTE2
LINE_ATTRIBUTE3
LINE_ATTRIBUTE4
LINE_ATTRIBUTE5
LINE_ATTRIBUTE6
LINE_ATTRIBUTE7
LINE_ATTRIBUTE8
LINE_ATTRIBUTE9
LINE_ATTRIBUTE10
LINE_ATTRIBUTE11
LINE_ATTRIBUTE12
LINE_ATTRIBUTE13
LINE_ATTRIBUTE14
LINE_ATTRIBUTE15
LINE_ATTRIBUTE16
LINE_ATTRIBUTE17
LINE_ATTRIBUTE18
LINE_ATTRIBUTE19
LINE_ATTRIBUTE20
LINE_ATTRIBUTE21
LINE_ATTRIBUTE22
LINE_ATTRIBUTE23
LINE_ATTRIBUTE24
LINE_ATTRIBUTE25
LINE_ATTRIBUTE26
LINE_ATTRIBUTE27
LINE_ATTRIBUTE28
LINE_ATTRIBUTE29
LINE_ATTRIBUTE30
SUPPLIER_PART_NUM
PRIOR_PRICE
CHANGE_TYPE
CHANGE_VALUE