eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CST_PROJMFG_CMT_BASIC_V

Source

View Text - Preformatted


SELECT mmt.project_id, nvl(mmt.task_id, PJM_TASK_AUTO_ASSIGN.INV_TASK_WNPS( mmt.organization_id, mmt.project_id, mmt.inventory_item_id, poh.po_header_id, NULL, mmt.subinventory_code)), 'ORACLE_MANUFACTURING', 'P', poh.segment1, rct.PO_DISTRIBUTION_ID, mmt.transaction_source_id, pol.item_description, mmt.transaction_date, pp.PERIOD_NAME, pp.GL_PERIOD_NAME, pol.line_num, pol.creation_date, to_date(NULL), NULL, NULL, 'Y', to_date(NULL), to_date(NULL), mmt.organization_id, pov.vendor_id, pov.vendor_name, project_mfg.matl_subelement(mmt.inventory_item_id, mp.avg_rates_cost_type_id, mmt.organization_id), pet.expenditure_category , pet.revenue_category_code, 'INVENTORY', msi.PRIMARY_UOM_CODE, to_number(NULL), to_number(NULL), cost1.actual_cost*mmt.primary_quantity, (cost2.actual_cost+cost1.actual_cost)*mmt.primary_quantity, cost1.actual_cost*mmt.primary_quantity, (cost2.actual_cost+cost1.actual_cost)*mmt.primary_quantity, mmt.primary_quantity, to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), substr(to_char(mmt.transaction_id),1,15), substr('               ',1,15), substr('               ',1,15), to_date(NULL), to_number(NULL), to_date(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_date(NULL), to_date(NULL), to_char(NULL), to_number(NULL), gsob.currency_code, gsob.currency_code, msi.inventory_item_id, msi.concatenated_segments, to_number(NULL), to_char(NULL), muom.unit_of_measure_tl, pp.org_id FROM GL_SETS_OF_BOOKS gsob, HR_ORGANIZATION_INFORMATION ood, MTL_MATERIAL_TRANSACTIONS mmt, RCV_TRANSACTIONS rct, PO_HEADERS_ALL poh, PO_LINES_ALL pol, MTL_PARAMETERS mp, MTL_SYSTEM_ITEMS_KFV msi, mtl_cst_actual_cost_details cost1, mtl_cst_actual_cost_details cost2, pa_periods pp, pa_expenditure_types pet, mtl_units_of_measure_tl muom, po_vendors pov WHERE ood.org_information1 = to_char(gsob.set_of_books_id) AND ood.organization_id = mmt.organization_id AND ood.org_information_context = 'Accounting Information' AND mmt.transaction_source_type_id = 1 AND mmt.rcv_transaction_id = rct.transaction_id AND mmt.transaction_source_id = rct.po_header_id AND rct.po_header_id = poh.po_header_id AND pov.vendor_id = poh.vendor_id AND pol.po_line_id = rct.po_line_id AND pol.po_header_id = rct.po_header_id AND mp.organization_id = mmt.organization_id AND mmt.inventory_item_id = msi.inventory_item_id AND mmt.organization_id = msi.organization_id AND mmt.transaction_id = cost1.transaction_id AND cost1.cost_element_id = 1 AND cost1.level_type = 1 AND mmt.transaction_id = cost2.transaction_id AND cost2.cost_element_id = 2 AND cost2.level_type = 1 AND pp.CURRENT_PA_PERIOD_FLAG = 'Y' AND pet.expenditure_type = project_mfg.matl_subelement(mmt.inventory_item_id, mp.avg_rates_cost_type_id, mmt.organization_id) AND mmt.pm_cost_collected IN ( 'N', 'E') AND muom.UOM_CODE = MSI.PRIMARY_UOM_CODE AND muom.LANGUAGE = USERENV('LANG') UNION ALL SELECT mmt.project_id, nvl(mmt.task_id, PJM_TASK_AUTO_ASSIGN.INV_TASK_WNPS( mmt.organization_id, mmt.project_id, mmt.inventory_item_id, NULL, NULL, mmt.subinventory_code)), 'ORACLE_MANUFACTURING', 'R', rh.segment1, rct.REQ_DISTRIBUTION_ID, mmt.transaction_source_id, RL.ITEM_DESCRIPTION, mmt.transaction_date, pp.PERIOD_NAME, pp.GL_PERIOD_NAME, RL.LINE_NUM, RL.CREATION_DATE, to_date(NULL), NULL, NULL, 'Y', to_date(NULL), to_date(NULL), mmt.organization_id, pov.vendor_id, pov.vendor_name, decode(mmt.transaction_action_id, 12,nvl(cceet.EXPENDITURE_TYPE_IN,'NoVal'), decode(sign(mmt.primary_quantity),1, nvl(cceet.EXPENDITURE_TYPE_IN,'NoVal'), nvl(cceet.EXPENDITURE_TYPE_OUT,'NoVal'))) , pet.EXPENDITURE_CATEGORY, pet.REVENUE_CATEGORY_CODE, 'INVENTORY', msi.PRIMARY_UOM_CODE, to_number(NULL), to_number(NULL), cost1.actual_cost, (cost2.actual_cost+cost1.actual_cost)*mmt.primary_quantity, cost1.actual_cost, (cost2.actual_cost+cost1.actual_cost)*mmt.primary_quantity, mmt.primary_quantity, to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), substr(to_char(mmt.transaction_id),1,15), substr('               ',1,15), substr('               ',1,15), to_date(NULL), to_number(NULL), to_date(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_date(NULL), to_date(NULL), to_char(NULL), to_number(NULL), gsob.currency_code, gsob.currency_code, msi.inventory_item_id, msi.concatenated_segments, to_number(NULL), to_char(NULL), muom.unit_of_measure_tl, pp.org_id from GL_SETS_OF_BOOKS gsob, HR_ORGANIZATION_INFORMATION ood, MTL_MATERIAL_TRANSACTIONS mmt, RCV_TRANSACTIONS rct, PO_REQUISITION_HEADERS_ALL rh, PO_REQUISITION_LINES_ALL rl, MTL_SYSTEM_ITEMS_KFV msi , mtl_cst_actual_cost_details cost1 , mtl_cst_actual_cost_details cost2 , cst_cost_elem_exp_types cceet , pa_expenditure_types pet , pa_periods pp, mtl_units_of_measure_tl muom, po_vendors pov WHERE ood.org_information1 = to_char(gsob.set_of_books_id) AND ood.organization_id = mmt.organization_id AND ood.org_information_context = 'Accounting Information' AND mmt.transaction_source_type_id = 7 AND mmt.rcv_transaction_id = rct.transaction_id AND mmt.transaction_source_id = rh.requisition_header_id AND rct.requisition_line_id = rl.requisition_line_id AND pov.vendor_id = rl.vendor_id AND mmt.inventory_item_id = msi.inventory_item_id AND mmt.organization_id = msi.organization_id AND mmt.transaction_id = cost1.transaction_id AND cost1.cost_element_id = 1 AND cost1.level_type = 1 AND mmt.transaction_id = cost2.transaction_id AND cost2.cost_element_id = 2 AND cost2.level_type = 1 AND cceet.cost_element_id = 1 AND decode(mmt.transaction_action_id, 12,nvl(cceet.EXPENDITURE_TYPE_IN,'NoVal'), decode(sign(mmt.primary_quantity),1, nvl(cceet.EXPENDITURE_TYPE_IN,'NoVal'), nvl(cceet.EXPENDITURE_TYPE_OUT,'NoVal'))) = pet.EXPENDITURE_TYPE AND pp.CURRENT_PA_PERIOD_FLAG = 'Y' AND mmt.pm_cost_collected IN ( 'N', 'E') AND MUOM.UOM_CODE = MSI.PRIMARY_UOM_CODE AND MUOM.LANGUAGE = USERENV('LANG') UNION ALL SELECT wt.project_id, nvl(wt.task_id, PJM_TASK_AUTO_ASSIGN.WIP_TASK_WNPS( wt.organization_id, wt.project_id, wo.standard_operation_id, wdj.wip_entity_id, wdj.primary_item_id, wo.department_id)), 'ORACLE_MANUFACTURING', 'P', poh.segment1, rct.PO_DISTRIBUTION_ID, wt.po_header_id, pol.item_description, wt.transaction_date, pp.PERIOD_NAME, pp.GL_PERIOD_NAME, pol.line_num, pol.creation_date, to_date(NULL), NULL, NULL, 'Y', to_date(NULL), to_date(NULL), wt.organization_id, pov.vendor_id, pov.vendor_name, decode(wt.resource_id,NULL,ppp.dir_item_expenditure_type,br.expenditure_type), pet.expenditure_category, pet.revenue_category_code, 'WORK_IN_PROCESS', wt.PRIMARY_UOM, to_number(NULL), to_number(NULL), wta.base_transaction_value, wta.base_transaction_value, wta.base_transaction_value, wta.base_transaction_value, wt.primary_quantity, to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), substr(to_char(wt.transaction_id),1,15), substr('               ',1,15), substr('               ',1,15), to_date(NULL), to_number(NULL), to_date(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_date(NULL), to_date(NULL), to_char(NULL), to_number(NULL), gsob.currency_code, gsob.currency_code, to_number(NULL), to_char(NULL), wt.resource_id, DECODE(WT.RESOURCE_ID,NULL,to_char(NULL),BR.RESOURCE_CODE), Decode(wt.primary_uom,NULL,to_char(NULL),MUOM.UNIT_OF_MEASURE_TL), pp.org_id FROM GL_SETS_OF_BOOKS gsob, HR_ORGANIZATION_INFORMATION ood, WIP_TRANSACTIONS wt, RCV_TRANSACTIONS rct, PO_HEADERS_ALL poh, PO_LINES_ALL pol, WIP_DISCRETE_JOBS wdj, WIP_OPERATIONS wo, BOM_RESOURCES br , WIP_TRANSACTION_ACCOUNTS wta , pa_periods pp, pa_expenditure_types pet, pjm_project_parameters ppp, mtl_units_of_measure_tl muom, po_vendors pov WHERE ood.org_information1 = to_char(gsob.set_of_books_id) AND ood.organization_id = wt.organization_id AND ood.org_information_context = 'Accounting Information' AND wt.source_code = 'RCV' AND wt.rcv_transaction_id = rct.transaction_id AND wt.po_header_id = poh.po_header_id AND pov.vendor_id = poh.vendor_id AND wt.po_line_id = pol.po_line_id AND wt.transaction_id = wta.transaction_id AND wta.cost_element_id IN (1,4) AND wta.accounting_line_type = 7 AND wt.wip_entity_id = wdj.wip_entity_id AND wt.resource_id = br.resource_id(+) AND wt.organization_id = br.organization_id(+) AND wt.project_id = ppp.project_id AND wt.organization_id = ppp.organization_id AND decode(wt.resource_id,NULL, ppp.dir_item_expenditure_type,br.expenditure_type) = pet.expenditure_type AND pp.CURRENT_PA_PERIOD_FLAG = 'Y' AND wt.pm_cost_collected IN ( 'N', 'E') AND WO.organization_id = WT.organization_id AND WO.wip_entity_id = WT.wip_entity_id AND WO.operation_seq_num = WT.operation_seq_num AND MUOM.uom_code(+) = wt.primary_uom AND MUOM.language(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT MMT.PROJECT_ID
, NVL(MMT.TASK_ID
, PJM_TASK_AUTO_ASSIGN.INV_TASK_WNPS( MMT.ORGANIZATION_ID
, MMT.PROJECT_ID
, MMT.INVENTORY_ITEM_ID
, POH.PO_HEADER_ID
, NULL
, MMT.SUBINVENTORY_CODE))
, 'ORACLE_MANUFACTURING'
, 'P'
, POH.SEGMENT1
, RCT.PO_DISTRIBUTION_ID
, MMT.TRANSACTION_SOURCE_ID
, POL.ITEM_DESCRIPTION
, MMT.TRANSACTION_DATE
, PP.PERIOD_NAME
, PP.GL_PERIOD_NAME
, POL.LINE_NUM
, POL.CREATION_DATE
, TO_DATE(NULL)
, NULL
, NULL
, 'Y'
, TO_DATE(NULL)
, TO_DATE(NULL)
, MMT.ORGANIZATION_ID
, POV.VENDOR_ID
, POV.VENDOR_NAME
, PROJECT_MFG.MATL_SUBELEMENT(MMT.INVENTORY_ITEM_ID
, MP.AVG_RATES_COST_TYPE_ID
, MMT.ORGANIZATION_ID)
, PET.EXPENDITURE_CATEGORY
, PET.REVENUE_CATEGORY_CODE
, 'INVENTORY'
, MSI.PRIMARY_UOM_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, COST1.ACTUAL_COST*MMT.PRIMARY_QUANTITY
, (COST2.ACTUAL_COST+COST1.ACTUAL_COST)*MMT.PRIMARY_QUANTITY
, COST1.ACTUAL_COST*MMT.PRIMARY_QUANTITY
, (COST2.ACTUAL_COST+COST1.ACTUAL_COST)*MMT.PRIMARY_QUANTITY
, MMT.PRIMARY_QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUBSTR(TO_CHAR(MMT.TRANSACTION_ID)
, 1
, 15)
, SUBSTR(' '
, 1
, 15)
, SUBSTR(' '
, 1
, 15)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, GSOB.CURRENCY_CODE
, MSI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, MUOM.UNIT_OF_MEASURE_TL
, PP.ORG_ID
FROM GL_SETS_OF_BOOKS GSOB
, HR_ORGANIZATION_INFORMATION OOD
, MTL_MATERIAL_TRANSACTIONS MMT
, RCV_TRANSACTIONS RCT
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_CST_ACTUAL_COST_DETAILS COST1
, MTL_CST_ACTUAL_COST_DETAILS COST2
, PA_PERIODS PP
, PA_EXPENDITURE_TYPES PET
, MTL_UNITS_OF_MEASURE_TL MUOM
, PO_VENDORS POV
WHERE OOD.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)
AND OOD.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND OOD.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 1
AND MMT.RCV_TRANSACTION_ID = RCT.TRANSACTION_ID
AND MMT.TRANSACTION_SOURCE_ID = RCT.PO_HEADER_ID
AND RCT.PO_HEADER_ID = POH.PO_HEADER_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND POL.PO_LINE_ID = RCT.PO_LINE_ID
AND POL.PO_HEADER_ID = RCT.PO_HEADER_ID
AND MP.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MMT.TRANSACTION_ID = COST1.TRANSACTION_ID
AND COST1.COST_ELEMENT_ID = 1
AND COST1.LEVEL_TYPE = 1
AND MMT.TRANSACTION_ID = COST2.TRANSACTION_ID
AND COST2.COST_ELEMENT_ID = 2
AND COST2.LEVEL_TYPE = 1
AND PP.CURRENT_PA_PERIOD_FLAG = 'Y'
AND PET.EXPENDITURE_TYPE = PROJECT_MFG.MATL_SUBELEMENT(MMT.INVENTORY_ITEM_ID
, MP.AVG_RATES_COST_TYPE_ID
, MMT.ORGANIZATION_ID)
AND MMT.PM_COST_COLLECTED IN ( 'N'
, 'E')
AND MUOM.UOM_CODE = MSI.PRIMARY_UOM_CODE
AND MUOM.LANGUAGE = USERENV('LANG') UNION ALL SELECT MMT.PROJECT_ID
, NVL(MMT.TASK_ID
, PJM_TASK_AUTO_ASSIGN.INV_TASK_WNPS( MMT.ORGANIZATION_ID
, MMT.PROJECT_ID
, MMT.INVENTORY_ITEM_ID
, NULL
, NULL
, MMT.SUBINVENTORY_CODE))
, 'ORACLE_MANUFACTURING'
, 'R'
, RH.SEGMENT1
, RCT.REQ_DISTRIBUTION_ID
, MMT.TRANSACTION_SOURCE_ID
, RL.ITEM_DESCRIPTION
, MMT.TRANSACTION_DATE
, PP.PERIOD_NAME
, PP.GL_PERIOD_NAME
, RL.LINE_NUM
, RL.CREATION_DATE
, TO_DATE(NULL)
, NULL
, NULL
, 'Y'
, TO_DATE(NULL)
, TO_DATE(NULL)
, MMT.ORGANIZATION_ID
, POV.VENDOR_ID
, POV.VENDOR_NAME
, DECODE(MMT.TRANSACTION_ACTION_ID
, 12
, NVL(CCEET.EXPENDITURE_TYPE_IN
, 'NOVAL')
, DECODE(SIGN(MMT.PRIMARY_QUANTITY)
, 1
, NVL(CCEET.EXPENDITURE_TYPE_IN
, 'NOVAL')
, NVL(CCEET.EXPENDITURE_TYPE_OUT
, 'NOVAL')))
, PET.EXPENDITURE_CATEGORY
, PET.REVENUE_CATEGORY_CODE
, 'INVENTORY'
, MSI.PRIMARY_UOM_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, COST1.ACTUAL_COST
, (COST2.ACTUAL_COST+COST1.ACTUAL_COST)*MMT.PRIMARY_QUANTITY
, COST1.ACTUAL_COST
, (COST2.ACTUAL_COST+COST1.ACTUAL_COST)*MMT.PRIMARY_QUANTITY
, MMT.PRIMARY_QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUBSTR(TO_CHAR(MMT.TRANSACTION_ID)
, 1
, 15)
, SUBSTR(' '
, 1
, 15)
, SUBSTR(' '
, 1
, 15)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, GSOB.CURRENCY_CODE
, MSI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, MUOM.UNIT_OF_MEASURE_TL
, PP.ORG_ID
FROM GL_SETS_OF_BOOKS GSOB
, HR_ORGANIZATION_INFORMATION OOD
, MTL_MATERIAL_TRANSACTIONS MMT
, RCV_TRANSACTIONS RCT
, PO_REQUISITION_HEADERS_ALL RH
, PO_REQUISITION_LINES_ALL RL
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_CST_ACTUAL_COST_DETAILS COST1
, MTL_CST_ACTUAL_COST_DETAILS COST2
, CST_COST_ELEM_EXP_TYPES CCEET
, PA_EXPENDITURE_TYPES PET
, PA_PERIODS PP
, MTL_UNITS_OF_MEASURE_TL MUOM
, PO_VENDORS POV
WHERE OOD.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)
AND OOD.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND OOD.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 7
AND MMT.RCV_TRANSACTION_ID = RCT.TRANSACTION_ID
AND MMT.TRANSACTION_SOURCE_ID = RH.REQUISITION_HEADER_ID
AND RCT.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID
AND POV.VENDOR_ID = RL.VENDOR_ID
AND MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MMT.TRANSACTION_ID = COST1.TRANSACTION_ID
AND COST1.COST_ELEMENT_ID = 1
AND COST1.LEVEL_TYPE = 1
AND MMT.TRANSACTION_ID = COST2.TRANSACTION_ID
AND COST2.COST_ELEMENT_ID = 2
AND COST2.LEVEL_TYPE = 1
AND CCEET.COST_ELEMENT_ID = 1
AND DECODE(MMT.TRANSACTION_ACTION_ID
, 12
, NVL(CCEET.EXPENDITURE_TYPE_IN
, 'NOVAL')
, DECODE(SIGN(MMT.PRIMARY_QUANTITY)
, 1
, NVL(CCEET.EXPENDITURE_TYPE_IN
, 'NOVAL')
, NVL(CCEET.EXPENDITURE_TYPE_OUT
, 'NOVAL'))) = PET.EXPENDITURE_TYPE
AND PP.CURRENT_PA_PERIOD_FLAG = 'Y'
AND MMT.PM_COST_COLLECTED IN ( 'N'
, 'E')
AND MUOM.UOM_CODE = MSI.PRIMARY_UOM_CODE
AND MUOM.LANGUAGE = USERENV('LANG') UNION ALL SELECT WT.PROJECT_ID
, NVL(WT.TASK_ID
, PJM_TASK_AUTO_ASSIGN.WIP_TASK_WNPS( WT.ORGANIZATION_ID
, WT.PROJECT_ID
, WO.STANDARD_OPERATION_ID
, WDJ.WIP_ENTITY_ID
, WDJ.PRIMARY_ITEM_ID
, WO.DEPARTMENT_ID))
, 'ORACLE_MANUFACTURING'
, 'P'
, POH.SEGMENT1
, RCT.PO_DISTRIBUTION_ID
, WT.PO_HEADER_ID
, POL.ITEM_DESCRIPTION
, WT.TRANSACTION_DATE
, PP.PERIOD_NAME
, PP.GL_PERIOD_NAME
, POL.LINE_NUM
, POL.CREATION_DATE
, TO_DATE(NULL)
, NULL
, NULL
, 'Y'
, TO_DATE(NULL)
, TO_DATE(NULL)
, WT.ORGANIZATION_ID
, POV.VENDOR_ID
, POV.VENDOR_NAME
, DECODE(WT.RESOURCE_ID
, NULL
, PPP.DIR_ITEM_EXPENDITURE_TYPE
, BR.EXPENDITURE_TYPE)
, PET.EXPENDITURE_CATEGORY
, PET.REVENUE_CATEGORY_CODE
, 'WORK_IN_PROCESS'
, WT.PRIMARY_UOM
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, WTA.BASE_TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE
, WT.PRIMARY_QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUBSTR(TO_CHAR(WT.TRANSACTION_ID)
, 1
, 15)
, SUBSTR(' '
, 1
, 15)
, SUBSTR(' '
, 1
, 15)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, GSOB.CURRENCY_CODE
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, WT.RESOURCE_ID
, DECODE(WT.RESOURCE_ID
, NULL
, TO_CHAR(NULL)
, BR.RESOURCE_CODE)
, DECODE(WT.PRIMARY_UOM
, NULL
, TO_CHAR(NULL)
, MUOM.UNIT_OF_MEASURE_TL)
, PP.ORG_ID
FROM GL_SETS_OF_BOOKS GSOB
, HR_ORGANIZATION_INFORMATION OOD
, WIP_TRANSACTIONS WT
, RCV_TRANSACTIONS RCT
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, WIP_DISCRETE_JOBS WDJ
, WIP_OPERATIONS WO
, BOM_RESOURCES BR
, WIP_TRANSACTION_ACCOUNTS WTA
, PA_PERIODS PP
, PA_EXPENDITURE_TYPES PET
, PJM_PROJECT_PARAMETERS PPP
, MTL_UNITS_OF_MEASURE_TL MUOM
, PO_VENDORS POV
WHERE OOD.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)
AND OOD.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND OOD.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND WT.SOURCE_CODE = 'RCV'
AND WT.RCV_TRANSACTION_ID = RCT.TRANSACTION_ID
AND WT.PO_HEADER_ID = POH.PO_HEADER_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND WT.PO_LINE_ID = POL.PO_LINE_ID
AND WT.TRANSACTION_ID = WTA.TRANSACTION_ID
AND WTA.COST_ELEMENT_ID IN (1
, 4)
AND WTA.ACCOUNTING_LINE_TYPE = 7
AND WT.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WT.RESOURCE_ID = BR.RESOURCE_ID(+)
AND WT.ORGANIZATION_ID = BR.ORGANIZATION_ID(+)
AND WT.PROJECT_ID = PPP.PROJECT_ID
AND WT.ORGANIZATION_ID = PPP.ORGANIZATION_ID
AND DECODE(WT.RESOURCE_ID
, NULL
, PPP.DIR_ITEM_EXPENDITURE_TYPE
, BR.EXPENDITURE_TYPE) = PET.EXPENDITURE_TYPE
AND PP.CURRENT_PA_PERIOD_FLAG = 'Y'
AND WT.PM_COST_COLLECTED IN ( 'N'
, 'E')
AND WO.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND WO.WIP_ENTITY_ID = WT.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WT.OPERATION_SEQ_NUM
AND MUOM.UOM_CODE(+) = WT.PRIMARY_UOM
AND MUOM.LANGUAGE(+) = USERENV('LANG')