VIEW: APPS.WIPFV_MFG_TRANSACTIONS

Source

View Text - Preformatted

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: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 */ , PA1.ORGANIZATION_CODE , AL1.NAME , EN.WIP_ENTITY_NAME , LI.LINE_CODE , AC.PERIOD_NAME , '_KF:INV:MSTK:sy' , DE.DEPARTMENT_CODE , RE.RESOURCE_CODE , PE.FULL_NAME , CAC.ACTIVITY , MTR.REASON_NAME , PR.PROJECT_NAME , PR.PROJECT_NUMBER , TA.TASK_NAME , TA.TASK_NUMBER , HE.SEGMENT1 , AL2.NAME , HE.TYPE_LOOKUP_CODE , PLI.LINE_NUM , '_KF:INV:MSTK:sy1' , '_DF:WIP:WIP_MOVE_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.COST_UPDATE_ID , TR.PROJECT_ID , TR.TASK_ID , TR.PO_HEADER_ID , TR.PO_LINE_ID , TR.RCV_TRANSACTION_ID , TR.SOURCE_LINE_ID /* WHO */ , TR.CREATION_DATE , TR.CREATED_BY , TR.LAST_UPDATE_DATE , TR.LAST_UPDATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL2 , PO_HEADERS_ALL HE , PO_LINES_ALL PLI , MTL_SYSTEM_ITEMS SY1 , RCV_TRANSACTIONS RTR , PJMFV_PROJECT_MFG_PROJECTS PR , PA_TASKS TA , CST_COST_UPDATES CO , WIP_MOVE_TRANSACTIONS MO , MTL_MATERIAL_TRANSACTIONS MA , MTL_TRANSACTION_REASONS MTR , CST_ACTIVITIES CAC , PER_ALL_PEOPLE_F PE , BOM_RESOURCES RE , BOM_DEPARTMENTS DE , MTL_SYSTEM_ITEMS SY , WIP_LINES LI , ORG_ACCT_PERIODS AC , WIP_ENTITIES EN , HR_ALL_ORGANIZATION_UNITS AL1 , MTL_PARAMETERS PA1 , WIP_TRANSACTIONS TR WHERE 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.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.EMPLOYEE_ID = PE.PERSON_ID (+) AND TR.TRANSACTION_DATE >= PE.EFFECTIVE_START_DATE (+) AND TR.TRANSACTION_DATE <= PE.EFFECTIVE_END_DATE (+) AND TR.RESOURCE_ID = RE.RESOURCE_ID (+) 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.COST_UPDATE_ID = CO.COST_UPDATE_ID (+) AND TR.PROJECT_ID = PR.PROJECT_ID (+) AND TR.TASK_ID = TA.TASK_ID (+) AND TR.PO_HEADER_ID = HE.PO_HEADER_ID (+) AND TR.PO_LINE_ID = PLI.PO_LINE_ID (+) AND SY1.INVENTORY_ITEM_ID (+) = PLI.ITEM_ID AND SY1.ORGANIZATION_ID (+) = PLI.ORG_ID AND TR.RCV_TRANSACTION_ID = RTR.TRANSACTION_ID (+) AND HE.ORG_ID = AL2.ORGANIZATION_ID (+) AND '_SEC:tr.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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: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 */
, PA1.ORGANIZATION_CODE
, AL1.NAME
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, AC.PERIOD_NAME
, '_KF:INV:MSTK:SY'
, DE.DEPARTMENT_CODE
, RE.RESOURCE_CODE
, PE.FULL_NAME
, CAC.ACTIVITY
, MTR.REASON_NAME
, PR.PROJECT_NAME
, PR.PROJECT_NUMBER
, TA.TASK_NAME
, TA.TASK_NUMBER
, HE.SEGMENT1
, AL2.NAME
, HE.TYPE_LOOKUP_CODE
, PLI.LINE_NUM
, '_KF:INV:MSTK:SY1'
, '_DF:WIP:WIP_MOVE_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.COST_UPDATE_ID
, TR.PROJECT_ID
, TR.TASK_ID
, TR.PO_HEADER_ID
, TR.PO_LINE_ID
, TR.RCV_TRANSACTION_ID
, TR.SOURCE_LINE_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL2
, PO_HEADERS_ALL HE
, PO_LINES_ALL PLI
, MTL_SYSTEM_ITEMS SY1
, RCV_TRANSACTIONS RTR
, PJMFV_PROJECT_MFG_PROJECTS PR
, PA_TASKS TA
, CST_COST_UPDATES CO
, WIP_MOVE_TRANSACTIONS MO
, MTL_MATERIAL_TRANSACTIONS MA
, MTL_TRANSACTION_REASONS MTR
, CST_ACTIVITIES CAC
, PER_ALL_PEOPLE_F PE
, BOM_RESOURCES RE
, BOM_DEPARTMENTS DE
, MTL_SYSTEM_ITEMS SY
, WIP_LINES LI
, ORG_ACCT_PERIODS AC
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA1
, WIP_TRANSACTIONS TR
WHERE 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.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.EMPLOYEE_ID = PE.PERSON_ID (+)
AND TR.TRANSACTION_DATE >= PE.EFFECTIVE_START_DATE (+)
AND TR.TRANSACTION_DATE <= PE.EFFECTIVE_END_DATE (+)
AND TR.RESOURCE_ID = RE.RESOURCE_ID (+)
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.COST_UPDATE_ID = CO.COST_UPDATE_ID (+)
AND TR.PROJECT_ID = PR.PROJECT_ID (+)
AND TR.TASK_ID = TA.TASK_ID (+)
AND TR.PO_HEADER_ID = HE.PO_HEADER_ID (+)
AND TR.PO_LINE_ID = PLI.PO_LINE_ID (+)
AND SY1.INVENTORY_ITEM_ID (+) = PLI.ITEM_ID
AND SY1.ORGANIZATION_ID (+) = PLI.ORG_ID
AND TR.RCV_TRANSACTION_ID = RTR.TRANSACTION_ID (+)
AND HE.ORG_ID = AL2.ORGANIZATION_ID (+)
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY