View: WIPFV_OVERHEAD_MFG_TXNS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_OVERHEAD_MFG_TXNS

View Text

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID
, '_LA:TR.TRANSACTION_TYPE:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING'
, TR.TRANSACTION_DATE
, TR.SOURCE_CODE
, TR.OPERATION_SEQ_NUM
, '_LA:TR.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, '_LA:TR.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, TR.TRANSACTION_QUANTITY
, TR.TRANSACTION_UOM
, TR.PRIMARY_QUANTITY
, TR.PRIMARY_UOM
, TR.STANDARD_RATE_FLAG
, TR.CURRENCY_CODE
, TR.CURRENCY_CONVERSION_DATE
, TR.CURRENCY_CONVERSION_RATE
, TR.CURRENCY_CONVERSION_TYPE
, TR.REFERENCE /* FOREIGN KEYS RESOLVED */
, PA1.ORGANIZATION_CODE
, AL1.NAME
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, AC.PERIOD_NAME
, '_KF:INV:MSTK:SY'
, DE.DEPARTMENT_CODE
, MTR.REASON_NAME
, PR.PROJECT_NAME
, PR.PROJECT_NUMBER
, TA.TASK_NAME
, TA.TASK_NUMBER
, '_DF:WIP:WIP_TRANSACTIONS:TR' /* IDS */
, TR.ORGANIZATION_ID
, TR.WIP_ENTITY_ID
, TR.LINE_ID
, TR.PRIMARY_ITEM_ID
, TR.ACCT_PERIOD_ID
, TR.DEPARTMENT_ID
, TR.REASON_ID
, TR.MOVE_TRANSACTION_ID
, TR.COMPLETION_TRANSACTION_ID
, TR.PROJECT_ID
, TR.TASK_ID
, TR.SOURCE_LINE_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM PA_TASKS TA
, PJMFV_PROJECT_MFG_PROJECTS PR
, MTL_MATERIAL_TRANSACTIONS MA
, WIP_MOVE_TRANSACTIONS MO
, MTL_TRANSACTION_REASONS MTR
, WIP_LINES LI
, MTL_SYSTEM_ITEMS SY
, BOM_DEPARTMENTS DE
, ORG_ACCT_PERIODS AC
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA1
, WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 2
AND TR.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND TR.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND TR.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND TR.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND TR.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND TR.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND TR.ACCT_PERIOD_ID = AC.ACCT_PERIOD_ID
AND TR.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND TR.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND TR.LINE_ID = LI.LINE_ID (+)
AND TR.ORGANIZATION_ID = LI.ORGANIZATION_ID (+)
AND TR.REASON_ID = MTR.REASON_ID (+)
AND TR.MOVE_TRANSACTION_ID = MO.TRANSACTION_ID (+)
AND TR.COMPLETION_TRANSACTION_ID = MA.TRANSACTION_ID (+)
AND TR.PROJECT_ID = PR.PROJECT_ID (+)
AND TR.TASK_ID = TA.TASK_ID (+)
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns