VIEW: APPS.WIP_COST_TXN_INTERFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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