View: CST_XLA_WIP_HEADERS_V

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

View Text

SELECT X.EVENT_ID
, 'WIP_TRANSACTION_ACCOUNTS' DISTRIBUTION_TYPE
, X.CURRENCY_CODE
, X.CURRENCY_CONVERSION_DATE
, X.CURRENCY_CONVERSION_RATE
, X.CURRENCY_CONVERSION_TYPE
, X.TRANSACTION_ID
, X.TRANSACTION_DATE
, X.WIP_TRANSACTION_TYPE_ID
, X.TRANSACTION_SOURCE_CODE
, X.TRANSACTION_SOURCE_LINE_ID
, X.WIP_ENTITY_ID
, X.ORGANIZATION_ID
, X.RESOURCE_ID
, X.WIP_TXN_BASIS_TYPE
, X.EMPLOYEE_ID
, X.DEPT_ID
, X.CHG_DEPT_ID
, X.LINE_ID
, X.OPERATION_SEQ_NUM
, X.RES_SEQ_NUM
, X.TRANSACTION_REASON_ID
, CDO.ACTIVITY_ID
, X.BASIS_RESOURCE_ID
, X.MOVE_TRANSACTION_ID
, X.TRANSACTION_QUANTITY
, X.TRANSACTION_UOM
, X.PRIMARY_QUANTITY
, X.PRIMARY_UOM
, X.USAGE_RATE_OR_AMOUNT
, X.STANDARD_RATE_FLAG
, X.AUTOCHARGE_TYPE
, X.ACTUAL_RESOURCE_RATE
, X.STANDARD_RESOURCE_RATE
, X.COST_UPDATE_ID
, X.INSTANCE_ID
, X.TRANSACTION_REFERENCE
, X.INVENTORY_ITEM_ID
, X.COMPLETION_TRANSACTION_ID
, X.TRANSACTION_ATTRIBUTE_CATEGORY
, X.TRANSACTION_ATTRIBUTE1
, X.TRANSACTION_ATTRIBUTE2
, X.TRANSACTION_ATTRIBUTE3
, X.TRANSACTION_ATTRIBUTE4
, X.TRANSACTION_ATTRIBUTE5
, X.TRANSACTION_ATTRIBUTE6
, X.TRANSACTION_ATTRIBUTE7
, X.TRANSACTION_ATTRIBUTE8
, X.TRANSACTION_ATTRIBUTE9
, X.TRANSACTION_ATTRIBUTE10
, X.TRANSACTION_ATTRIBUTE11
, X.TRANSACTION_ATTRIBUTE12
, X.TRANSACTION_ATTRIBUTE13
, X.TRANSACTION_ATTRIBUTE14
, X.TRANSACTION_ATTRIBUTE15
, X.WIP_TXN_PROJECT_ID
, X.WIP_TXN_TASK_ID
, X.TRANSFER_TO_GL_INDICATOR
FROM ( SELECT XEG.EVENT_ID
, NVL(WT.CURRENCY_CODE
, GL.CURRENCY_CODE) CURRENCY_CODE
, WT.CURRENCY_CONVERSION_DATE
, DECODE(WT.CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
, GL.CURRENCY_CODE
, TO_NUMBER(NULL)
, WT.CURRENCY_CONVERSION_RATE ) CURRENCY_CONVERSION_RATE
, DECODE(WT.CURRENCY_CODE
, NULL
, NULL
, GL.CURRENCY_CODE
, NULL
, WT.CURRENCY_CONVERSION_TYPE ) CURRENCY_CONVERSION_TYPE
, WT.TRANSACTION_ID
, WT.TRANSACTION_DATE
, WT.TRANSACTION_TYPE WIP_TRANSACTION_TYPE_ID
, WT.SOURCE_CODE TRANSACTION_SOURCE_CODE
, WT.SOURCE_LINE_ID TRANSACTION_SOURCE_LINE_ID
, WT.WIP_ENTITY_ID
, WT.ORGANIZATION_ID
, XEG.SOURCE_ID_INT_2 RESOURCE_ID
, XEG.SOURCE_ID_INT_3 WIP_TXN_BASIS_TYPE
, WT.EMPLOYEE_ID
, WT.DEPARTMENT_ID DEPT_ID
, WT.CHARGE_DEPARTMENT_ID CHG_DEPT_ID
, WT.LINE_ID
, WT.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, WT.RESOURCE_SEQ_NUM RES_SEQ_NUM
, WT.REASON_ID TRANSACTION_REASON_ID
, WT.RESOURCE_ID BASIS_RESOURCE_ID
, WT.MOVE_TRANSACTION_ID
, WT.TRANSACTION_QUANTITY
, WT.TRANSACTION_UOM
, WT.PRIMARY_QUANTITY
, WT.PRIMARY_UOM
, WT.USAGE_RATE_OR_AMOUNT
, NVL(WT.STANDARD_RATE_FLAG
, 2) STANDARD_RATE_FLAG
, WT.AUTOCHARGE_TYPE
, WT.ACTUAL_RESOURCE_RATE
, WT.STANDARD_RESOURCE_RATE
, WT.COST_UPDATE_ID
, WT.INSTANCE_ID
, WT.REFERENCE TRANSACTION_REFERENCE
, WT.PRIMARY_ITEM_ID INVENTORY_ITEM_ID
, WT.COMPLETION_TRANSACTION_ID
, WT.ATTRIBUTE_CATEGORY TRANSACTION_ATTRIBUTE_CATEGORY
, WT.ATTRIBUTE1 TRANSACTION_ATTRIBUTE1
, WT.ATTRIBUTE2 TRANSACTION_ATTRIBUTE2
, WT.ATTRIBUTE3 TRANSACTION_ATTRIBUTE3
, WT.ATTRIBUTE4 TRANSACTION_ATTRIBUTE4
, WT.ATTRIBUTE5 TRANSACTION_ATTRIBUTE5
, WT.ATTRIBUTE6 TRANSACTION_ATTRIBUTE6
, WT.ATTRIBUTE7 TRANSACTION_ATTRIBUTE7
, WT.ATTRIBUTE8 TRANSACTION_ATTRIBUTE8
, WT.ATTRIBUTE9 TRANSACTION_ATTRIBUTE9
, WT.ATTRIBUTE10 TRANSACTION_ATTRIBUTE10
, WT.ATTRIBUTE11 TRANSACTION_ATTRIBUTE11
, WT.ATTRIBUTE12 TRANSACTION_ATTRIBUTE12
, WT.ATTRIBUTE13 TRANSACTION_ATTRIBUTE13
, WT.ATTRIBUTE14 TRANSACTION_ATTRIBUTE14
, WT.ATTRIBUTE15 TRANSACTION_ATTRIBUTE15
, WT.PROJECT_ID WIP_TXN_PROJECT_ID
, WT.TASK_ID WIP_TXN_TASK_ID
, DECODE(MP.GENERAL_LEDGER_UPDATE_CODE
, 3
, 'N'
, 'Y' ) TRANSFER_TO_GL_INDICATOR
, NVL(MP.AVG_RATES_COST_TYPE_ID
, MP.PRIMARY_COST_METHOD) COST_TYPE_ID
FROM WIP_TRANSACTIONS WT
, XLA_EVENTS_GT XEG
, MTL_PARAMETERS MP
, GL_LEDGERS GL
WHERE XEG.SOURCE_ID_INT_1 = WT.TRANSACTION_ID
AND XEG.ENTITY_CODE = 'WIP_ACCOUNTING_EVENTS'
AND MP.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND XEG.EVENT_TYPE_CODE = 'OVERHEAD_ABSORPTION'
AND GL.LEDGER_ID = XEG.LEDGER_ID ) X
, CST_DEPARTMENT_OVERHEADS CDO
WHERE CDO.DEPARTMENT_ID (+) = X.DEPT_ID
AND CDO.COST_TYPE_ID (+) = X.COST_TYPE_ID
AND CDO.OVERHEAD_ID (+)= X.RESOURCE_ID
AND CDO.BASIS_TYPE (+)= X.WIP_TXN_BASIS_TYPE UNION ALL SELECT XEG.EVENT_ID
, 'WIP_TRANSACTION_ACCOUNTS' DISTRIBUTION_TYPE
, NVL(WT.CURRENCY_CODE
, GL.CURRENCY_CODE) CURRENCY_CODE
, WT.CURRENCY_CONVERSION_DATE
, DECODE(WT.CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
, GL.CURRENCY_CODE
, TO_NUMBER(NULL)
, WT.CURRENCY_CONVERSION_RATE ) CURRENCY_CONVERSION_RATE
, DECODE(WT.CURRENCY_CODE
, NULL
, NULL
, GL.CURRENCY_CODE
, NULL
, WT.CURRENCY_CONVERSION_TYPE ) CURRENCY_CONVERSION_TYPE
, WT.TRANSACTION_ID
, WT.TRANSACTION_DATE
, WT.TRANSACTION_TYPE WIP_TRANSACTION_TYPE_ID
, WT.SOURCE_CODE TRANSACTION_SOURCE_CODE
, WT.SOURCE_LINE_ID TRANSACTION_SOURCE_LINE_ID
, WT.WIP_ENTITY_ID
, WT.ORGANIZATION_ID
, WT.RESOURCE_ID
, WT.BASIS_TYPE WIP_TXN_BASIS_TYPE
, WT.EMPLOYEE_ID
, WT.DEPARTMENT_ID DEPT_ID
, WT.CHARGE_DEPARTMENT_ID CHG_DEPT_ID
, WT.LINE_ID
, WT.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, WT.RESOURCE_SEQ_NUM RES_SEQ_NUM
, WT.REASON_ID TRANSACTION_REASON_ID
, WT.ACTIVITY_ID
, NULL BASIS_RESOURCE_ID
, WT.MOVE_TRANSACTION_ID
, WT.TRANSACTION_QUANTITY
, WT.TRANSACTION_UOM
, WT.PRIMARY_QUANTITY
, WT.PRIMARY_UOM
, WT.USAGE_RATE_OR_AMOUNT
, NVL(WT.STANDARD_RATE_FLAG
, 2) STANDARD_RATE_FLAG
, WT.AUTOCHARGE_TYPE
, WT.ACTUAL_RESOURCE_RATE
, WT.STANDARD_RESOURCE_RATE
, WT.COST_UPDATE_ID
, WT.INSTANCE_ID
, WT.REFERENCE TRANSACTION_REFERENCE
, WT.PRIMARY_ITEM_ID INVENTORY_ITEM_ID
, WT.COMPLETION_TRANSACTION_ID
, WT.ATTRIBUTE_CATEGORY TRANSACTION_ATTRIBUTE_CATEGORY
, WT.ATTRIBUTE1 TRANSACTION_ATTRIBUTE1
, WT.ATTRIBUTE2 TRANSACTION_ATTRIBUTE2
, WT.ATTRIBUTE3 TRANSACTION_ATTRIBUTE3
, WT.ATTRIBUTE4 TRANSACTION_ATTRIBUTE4
, WT.ATTRIBUTE5 TRANSACTION_ATTRIBUTE5
, WT.ATTRIBUTE6 TRANSACTION_ATTRIBUTE6
, WT.ATTRIBUTE7 TRANSACTION_ATTRIBUTE7
, WT.ATTRIBUTE8 TRANSACTION_ATTRIBUTE8
, WT.ATTRIBUTE9 TRANSACTION_ATTRIBUTE9
, WT.ATTRIBUTE10 TRANSACTION_ATTRIBUTE10
, WT.ATTRIBUTE11 TRANSACTION_ATTRIBUTE11
, WT.ATTRIBUTE12 TRANSACTION_ATTRIBUTE12
, WT.ATTRIBUTE13 TRANSACTION_ATTRIBUTE13
, WT.ATTRIBUTE14 TRANSACTION_ATTRIBUTE14
, WT.ATTRIBUTE15 TRANSACTION_ATTRIBUTE15
, WT.PROJECT_ID WIP_TXN_PROJECT_ID
, WT.TASK_ID WIP_TXN_TASK_ID
, DECODE(MP.GENERAL_LEDGER_UPDATE_CODE
, 3
, 'N'
, 'Y' ) TRANSFER_TO_GL_INDICATOR
FROM WIP_TRANSACTIONS WT
, XLA_EVENTS_GT XEG
, MTL_PARAMETERS MP
, GL_LEDGERS GL
WHERE XEG.SOURCE_ID_INT_1 = WT.TRANSACTION_ID
AND XEG.ENTITY_CODE = 'WIP_ACCOUNTING_EVENTS'
AND XEG.EVENT_TYPE_CODE != 'OVERHEAD_ABSORPTION'
AND MP.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND GL.LEDGER_ID = XEG.LEDGER_ID

Columns