View: CST_DISTRIBUTION_VIEW

Product:	BOM - Bills of Material
Description:	Summary of transaction value for Work In Process : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_DISTRIBUTION_VIEW

View Text

SELECT MMT.TRANSACTION_SOURCE_ID
, MMT.REPETITIVE_LINE_ID
, MMT.ACCT_PERIOD_ID
, MMT.ORGANIZATION_ID
, MTA.REFERENCE_ACCOUNT + 0
, MTA.TRANSACTION_DATE
, MMT.OPERATION_SEQ_NUM
, MMT.TRANSACTION_TYPE_ID
, MMT.INVENTORY_ITEM_ID
, MMT.PRIMARY_QUANTITY
, MTA.BASE_TRANSACTION_VALUE
, MSI.PRIMARY_UOM_CODE
, MTA.BASE_TRANSACTION_VALUE / DECODE(MMT.PRIMARY_QUANTITY
, 0
, 1
, NULL
, 1
, -1 * MMT.PRIMARY_QUANTITY)
, LU.MEANING
, -1
, MMT.TRANSACTION_ID
, MTA.COST_ELEMENT_ID
FROM MTL_TRANSACTION_ACCOUNTS MTA
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_SYSTEM_ITEMS_B MSI
, MFG_LOOKUPS LU
WHERE MTA.TRANSACTION_ID = MMT.TRANSACTION_ID
AND MMT.TRANSACTION_TYPE_ID IN (17
, 25
, 35
, 43
, 44
, 90
, 38
, 48)
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MTA.BASIS_TYPE = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'CST_BASIS' UNION SELECT WT.WIP_ENTITY_ID
, WT.LINE_ID
, WT.ACCT_PERIOD_ID
, WT.ORGANIZATION_ID
, WTA.REFERENCE_ACCOUNT
, WTA.TRANSACTION_DATE
, WT.OPERATION_SEQ_NUM
, WT.TRANSACTION_TYPE
, WTA.RESOURCE_ID
, SUM(WTA.PRIMARY_QUANTITY)
, SUM(WTA.BASE_TRANSACTION_VALUE)
, WT.PRIMARY_UOM
, SUM(WTA.BASE_TRANSACTION_VALUE) / SUM(DECODE( WTA.PRIMARY_QUANTITY
, 0
, 1
, NULL
, 1
, WTA.PRIMARY_QUANTITY))
, LU.MEANING
, WT.RESOURCE_SEQ_NUM
, WT.TRANSACTION_ID
, WTA.COST_ELEMENT_ID
FROM WIP_TRANSACTION_ACCOUNTS WTA
, WIP_TRANSACTIONS WT
, MFG_LOOKUPS LU
WHERE WTA.TRANSACTION_ID = WT.TRANSACTION_ID
AND WTA.ACCOUNTING_LINE_TYPE IN (7
, 99)
AND LU.LOOKUP_TYPE(+) = 'CST_BASIS'
AND LU.LOOKUP_CODE(+) = WTA.BASIS_TYPE GROUP BY WT.TRANSACTION_ID
, WT.WIP_ENTITY_ID
, WT.LINE_ID
, WT.ORGANIZATION_ID
, WT.ACCT_PERIOD_ID
, WTA.REFERENCE_ACCOUNT
, WTA.TRANSACTION_DATE
, WT.OPERATION_SEQ_NUM
, WT.TRANSACTION_TYPE
, WTA.RESOURCE_ID
, WT.PRIMARY_UOM
, LU.MEANING
, WT.RESOURCE_SEQ_NUM
, WTA.COST_ELEMENT_ID

Columns