View: WIPFV_MFG_RESOURCE_TXNS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_MFG_RESOURCE_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
, TR.RESOURCE_SEQ_NUM
, '_LA:TR.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, TR.USAGE_RATE_OR_AMOUNT
, '_LA:TR.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, TR.TRANSACTION_QUANTITY
, TR.TRANSACTION_UOM
, TR.PRIMARY_QUANTITY
, TR.PRIMARY_UOM
, TR.ACTUAL_RESOURCE_RATE
, TR.STANDARD_RESOURCE_RATE
, TR.STANDARD_RATE_FLAG
, TR.CURRENCY_CODE
, TR.CURRENCY_CONVERSION_DATE
, TR.CURRENCY_CONVERSION_RATE
, TR.CURRENCY_CONVERSION_TYPE
, TR.CURRENCY_ACTUAL_RESOURCE_RATE
, TR.REFERENCE /* FOREIGN KEYS RESOLVED */
, PA.ORGANIZATION_CODE
, AL.NAME
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, AC.PERIOD_NAME
, '_KF:INV:MSTK:SY'
, DE.DEPARTMENT_CODE
, RE.RESOURCE_CODE
, ALPE.FULL_NAME
, CAC.ACTIVITY
, 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.RESOURCE_ID
, TR.EMPLOYEE_ID
, TR.ACTIVITY_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 PJMFV_PROJECT_MFG_PROJECTS PR
, PA_TASKS TA
, MTL_MATERIAL_TRANSACTIONS MA
, WIP_MOVE_TRANSACTIONS MO
, MTL_TRANSACTION_REASONS MTR
, CST_ACTIVITIES CAC
, PER_ALL_PEOPLE_F ALPE
, BOM_RESOURCES RE
, BOM_DEPARTMENTS DE
, MTL_SYSTEM_ITEMS SY
, WIP_LINES LI
, ORG_ACCT_PERIODS AC
, WIP_ENTITIES EN
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 1
AND TR.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND TR.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND TR.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND TR.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND TR.ACCT_PERIOD_ID = AC.ACCT_PERIOD_ID
AND TR.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND TR.LINE_ID = LI.LINE_ID (+)
AND TR.ORGANIZATION_ID = LI.ORGANIZATION_ID (+)
AND TR.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID (+)
AND TR.ORGANIZATION_ID = SY.ORGANIZATION_ID (+)
AND TR.DEPARTMENT_ID = DE.DEPARTMENT_ID (+)
AND TR.RESOURCE_ID = RE.RESOURCE_ID (+)
AND TR.EMPLOYEE_ID = ALPE.PERSON_ID (+)
AND TR.TRANSACTION_DATE >= ALPE.EFFECTIVE_START_DATE (+)
AND TR.TRANSACTION_DATE <= ALPE.EFFECTIVE_END_DATE (+)
AND TR.ACTIVITY_ID = CAC.ACTIVITY_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