View: WIPFV_OSP_MFG_TXNS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_OSP_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
, 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 */
, 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
, 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_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.ACTIVITY_ID
, TR.REASON_ID
, TR.MOVE_TRANSACTION_ID
, TR.COMPLETION_TRANSACTION_ID
, TR.PROJECT_ID
, TR.TASK_ID
, TR.PO_HEADER_ID
, TR.PO_LINE_ID
, PLI.ITEM_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 PJMFV_PROJECT_MFG_PROJECTS PR
, PA_TASKS TA
, WIP_LINES LI
, CST_ACTIVITIES CAC
, MTL_TRANSACTION_REASONS MTR
, MTL_SYSTEM_ITEMS SY
, MTL_SYSTEM_ITEMS SY1
, PO_HEADERS_ALL HE
, PO_LINES_ALL PLI
, RCV_TRANSACTIONS RTR
, HR_ALL_ORGANIZATION_UNITS AL2
, BOM_DEPARTMENTS DE
, BOM_RESOURCES RE
, ORG_ACCT_PERIODS AC
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA1
, WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 3
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.RESOURCE_ID = RE.RESOURCE_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 TR.LINE_ID = LI.LINE_ID (+)
AND TR.ORGANIZATION_ID = LI.ORGANIZATION_ID (+)
AND TR.ACTIVITY_ID = CAC.ACTIVITY_ID (+)
AND TR.REASON_ID = MTR.REASON_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