View: WIP_COST_TXN_INTERFACE_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_COST_TXN_INTERFACE
Implementation/DBA Data:	APPS.WIP_COST_TXN_INTERFACE_V

View Text

SELECT WCTI.ROWID ROW_ID
, WCTI.TRANSACTION_ID
, WCTI.LAST_UPDATE_DATE
, WCTI.LAST_UPDATED_BY
, WCTI.LAST_UPDATED_BY_NAME
, WCTI.CREATION_DATE
, WCTI.CREATED_BY
, WCTI.CREATED_BY_NAME
, WCTI.LAST_UPDATE_LOGIN
, WCTI.REQUEST_ID
, WCTI.PROGRAM_APPLICATION_ID
, WCTI.PROGRAM_ID
, WCTI.PROGRAM_UPDATE_DATE
, WCTI.GROUP_ID
, WCTI.SOURCE_CODE
, WCTI.SOURCE_LINE_ID
, WCTI.PROCESS_PHASE
, ML5.MEANING PROCESS_PHASE_MEANING
, WCTI.PROCESS_STATUS
, ML6.MEANING PROCESS_STATUS_MEANING
, WCTI.TRANSACTION_TYPE
, ML.MEANING TRANSACTION_TYPE_MEANING
, WCTI.ORGANIZATION_ID
, WCTI.ORGANIZATION_CODE
, HAOU.NAME ORGANIZATION_NAME
, WCTI.WIP_ENTITY_ID
, NVL( WCTI.WIP_ENTITY_NAME
, WE.WIP_ENTITY_NAME)
, WCTI.ENTITY_TYPE
, WCTI.LINE_ID
, WCTI.LINE_CODE
, WCTI.PRIMARY_ITEM_ID
, WCTI.REPETITIVE_SCHEDULE_ID
, WCTI.TRANSACTION_DATE
, WCTI.ACCT_PERIOD_ID
, WCTI.OPERATION_SEQ_NUM
, WCTI.RESOURCE_SEQ_NUM
, DECODE(WOR.RESOURCE_SEQ_NUM
, NULL
, DECODE(WCTI.RESOURCE_SEQ_NUM
, NULL
, 2 /* NOT ADDING RESOURCE ON THE FLY */
, 1 /* YES ADDING RESOURCE ON THE FLY */)
, 2 /* NOT ADDING RESOURCE ON THE FLY */) NEW_RES_ADDED
, WCTI.DEPARTMENT_ID
, WCTI.DEPARTMENT_CODE
, WCTI.EMPLOYEE_ID
, WCTI.EMPLOYEE_NUM
, WCTI.RESOURCE_ID
, WCTI.RESOURCE_CODE
, WCTI.RESOURCE_TYPE
, ML7.MEANING RESOURCE_TYPE_MEANING
, WCTI.USAGE_RATE_OR_AMOUNT
, WCTI.BASIS_TYPE
, ML2.MEANING BASIS_TYPE_MEANING
, WCTI.AUTOCHARGE_TYPE
, ML3.MEANING AUTOCHARGE_TYPE_MEANING
, WCTI.STANDARD_RATE_FLAG
, ML4.MEANING STANDARD_RATE_FLAG_MEANING
, WCTI.TRANSACTION_QUANTITY
, WCTI.TRANSACTION_UOM
, WCTI.PRIMARY_QUANTITY
, WCTI.PRIMARY_UOM
, WCTI.PRIMARY_UOM_CLASS
, WCTI.ACTUAL_RESOURCE_RATE
, BR.FUNCTIONAL_CURRENCY_FLAG
, WCTI.CURRENCY_CODE
, WCTI.CURRENCY_CONVERSION_DATE
, WCTI.CURRENCY_CONVERSION_TYPE
, WCTI.CURRENCY_CONVERSION_RATE
, WCTI.CURRENCY_ACTUAL_RESOURCE_RATE
, WCTI.ACTIVITY_ID
, WCTI.ACTIVITY_NAME
, WCTI.REASON_ID
, WCTI.REASON_NAME
, WCTI.REFERENCE
, WCTI.MOVE_TRANSACTION_ID
, WCTI.RCV_TRANSACTION_ID
, WCTI.PO_HEADER_ID
, PH.SEGMENT1 PO_NUMBER
, WCTI.PO_LINE_ID
, WCTI.RECEIVING_ACCOUNT_ID
, WCTI.PROJECT_ID
, PA.SEGMENT1
, WCTI.TASK_ID
, PT.TASK_NUMBER
, WCTI.ATTRIBUTE_CATEGORY
, WCTI.ATTRIBUTE1
, WCTI.ATTRIBUTE2
, WCTI.ATTRIBUTE3
, WCTI.ATTRIBUTE4
, WCTI.ATTRIBUTE5
, WCTI.ATTRIBUTE6
, WCTI.ATTRIBUTE7
, WCTI.ATTRIBUTE8
, WCTI.ATTRIBUTE9
, WCTI.ATTRIBUTE10
, WCTI.ATTRIBUTE11
, WCTI.ATTRIBUTE12
, WCTI.ATTRIBUTE13
, WCTI.ATTRIBUTE14
, WCTI.ATTRIBUTE15
FROM PA_PROJECTS_ALL PA
, PA_TASKS PT
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, PO_HEADERS_ALL PH
, BOM_RESOURCES BR
, WIP_OPERATION_RESOURCES WOR
, WIP_COST_TXN_INTERFACE WCTI
, WIP_ENTITIES WE
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE PA.PROJECT_ID (+) = WCTI.PROJECT_ID
AND PT.TASK_ID (+) = WCTI.TASK_ID
AND ML.LOOKUP_TYPE (+) = 'WIP_TRANSACTION_TYPE'
AND ML.LOOKUP_CODE (+) = WCTI.TRANSACTION_TYPE
AND ML2.LOOKUP_TYPE (+) = 'CST_BASIS'
AND ML2.LOOKUP_CODE (+) = WCTI.BASIS_TYPE
AND ML3.LOOKUP_TYPE (+) = 'BOM_AUTOCHARGE_TYPE'
AND ML3.LOOKUP_CODE (+) = WCTI.AUTOCHARGE_TYPE
AND ML4.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND ML4.LOOKUP_CODE (+) = WCTI.STANDARD_RATE_FLAG
AND ML5.LOOKUP_TYPE = 'WIP_RESOURCE_PROCESS_PHASE'
AND ML5.LOOKUP_CODE = WCTI.PROCESS_PHASE
AND ML6.LOOKUP_TYPE = 'WIP_PROCESS_STATUS'
AND ML6.LOOKUP_CODE = WCTI.PROCESS_STATUS
AND ML7.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE'
AND ML7.LOOKUP_CODE (+) = WCTI.RESOURCE_TYPE
AND PH.PO_HEADER_ID (+) = WCTI.PO_HEADER_ID
AND BR.RESOURCE_ID (+) = WCTI.RESOURCE_ID
AND WOR.ORGANIZATION_ID (+) = WCTI.ORGANIZATION_ID
AND WOR.WIP_ENTITY_ID (+) = WCTI.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM (+) = WCTI.OPERATION_SEQ_NUM
AND WOR.RESOURCE_SEQ_NUM (+) = WCTI.RESOURCE_SEQ_NUM
AND NVL(WOR.REPETITIVE_SCHEDULE_ID (+)
, -1) = NVL(WCTI.REPETITIVE_SCHEDULE_ID
, -1)
AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+)
AND WCTI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID

Columns