ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4D108E28A00B4495B4700E006144432CY select mp.organization_code, wt.transaction_date, xxen_util.meaning(wt.transaction_type,'WIP_TRANSACTION_TYPE',700) transaction_type, we.wip_entity_name job, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) job_type, wl.line_code line, msiv.concatenated_segments assembly, msiv.description assembly_description, wt.operation_seq_num operation_seq, bd.department_code department, wt.resource_seq_num resource_seq, br.resource_code, br.description resource_description, xxen_util.meaning(br.resource_type,'BOM_RESOURCE_TYPE',700) resource_type, xxen_util.meaning(wt.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) charge_type, xxen_util.meaning(wt.basis_type,'CST_BASIS',700) basis, wt.usage_rate_or_amount usage_rate, wt.transaction_quantity quantity, wt.transaction_uom uom, wt.primary_quantity, wt.primary_uom, xxen_util.yes(case when wt.transaction_type<>2 and nvl(wt.standard_rate_flag,1)=1 then 'Y' end) standard_rate, wt.actual_resource_rate, wt.standard_resource_rate, ca.activity, nvl(papf.npw_number,papf.employee_number) employee_number, papf.full_name employee, mtr.reason_name reason, wt.reference, pha.segment1 po_number, ppa.segment1 project_number, pt.task_number, xxen_util.meaning(decode(wt.pm_cost_collected,null,nvl2(wt.pm_cost_collector_group_id,'1','4'),'N','2','E','3'),'INV_YES_NO_ERROR_NA',700) transferred_to_projects, wt.source_code, xxen_util.user_name(wt.created_by) created_by, wt.creation_date, wt.transaction_id from mtl_parameters mp, wip_transactions wt, wip_entities we, wip_lines wl, mtl_system_items_vl msiv, bom_departments bd, bom_resources br, cst_activities ca, per_all_people_f papf, mtl_transaction_reasons mtr, po_headers_all pha, pa_projects_all ppa, pa_tasks pt where 1=1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=wt.organization_id and wt.transaction_type in (1,2,3,4,5,6,7,17) and wt.wip_entity_id=we.wip_entity_id and wt.line_id=wl.line_id(+) and wt.organization_id=wl.organization_id(+) and wt.organization_id=msiv.organization_id(+) and wt.primary_item_id=msiv.inventory_item_id(+) and nvl(wt.charge_department_id,wt.department_id)=bd.department_id(+) and wt.resource_id=br.resource_id(+) and wt.activity_id=ca.activity_id(+) and wt.employee_id=papf.person_id(+) and wt.transaction_date>=papf.effective_start_date(+) and wt.transaction_date<papf.effective_end_date(+)+1 and wt.reason_id=mtr.reason_id(+) and wt.po_header_id=pha.po_header_id(+) and wt.project_id=ppa.project_id(+) and wt.task_id=pt.task_id(+) order by mp.organization_code, wt.transaction_date, wt.transaction_id New report listing WIP resource transactions, one row per transaction, with the View Resource Transactions form's selection criteria plus Resource Type. WIP :Date_From is not null or :Job is not null US WIP Resource Transactions WIP resource, overhead and outside processing transactions, one row per transaction, as shown in the View Resource Transactions form. Quantity is in the unit of measure the transaction was entered in, Primary Quantity in the resource's unit of measure. Transactions still pending in the resource transaction interface are not included. Please enter a Date From or a Job Enginatics 1=1 1 10 1=1 mp.organization_code=:organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or not exists (select null from xxen_report_org_access xroa where xroa.access_type='INV') and ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 2 20 1=1 wt.transaction_date>=:date_from DateTime US Date From 3 30 1=1 wt.transaction_date<:date_to+decode(:date_to,trunc(:date_to),1,0) DateTime US Date To A date without a time includes the whole day. With a time, transactions before that time are included, so consecutive windows such as 04:00 to 04:00 do not overlap. 4 40 1=1 we.wip_entity_name=:job LOV WIP Job 8E2FF36EDEC379D2E0530100007F1FF2 Y Y select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700)||' ('||ood.organization_code||')'||nvl2(we.description,': '||we.description,null) description from wip_entities we, org_organization_definitions ood where (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and ( :$flex$.organization_code is null and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' ) and we.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate and we.entity_type in (1,3,5,8) --(Discrete job, Closed discrete job, Lot based job, Closed lot based job) order by we.creation_date desc US Job 5 50 1=1 wl.line_code=:line LOV custom Y select distinct wl.line_code value, wl.description from mtl_parameters mp, wip_lines wl where (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and mp.organization_id=wl.organization_id order by wl.line_code US Line 6 60 1=1 msiv.concatenated_segments=:assembly LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Assembly 7 70 1=1 bd.department_code=:department LOV BOM Department (org code dependent) E7CCB27F39531272E0530100007F62B4 Y select bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd where :$flex$.organization_code is null or bd.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.organization_code) order by bd.department_code US Department 8 80 1=1 br.resource_code=:resource_code LOV BOM Resource Code (org code dependent) E7CCB27F39541272E0530100007F62B4 Y select br.resource_code value, br.description from bom_resources br where (:$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code US Resource 9 90 1=1 br.resource_type=to_number(xxen_util.lookup_code(:resource_type,'BOM_RESOURCE_TYPE',700)) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOM_RESOURCE_TYPE' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) US Resource Type 10 100 1=1 nvl(papf.npw_number,papf.employee_number)=:employee_number LOV custom select nvl(ppx.npw_number,ppx.employee_number) value, ppx.full_name description from per_people_x ppx, hr_organization_units hou where ppx.business_group_id+0=hou.business_group_id and hou.organization_id=nvl((select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.organization_code),fnd_profile.value('MFG_ORGANIZATION_ID')) order by nvl(ppx.npw_number,ppx.employee_number), ppx.full_name US Employee Number 11 110 1=1 ca.activity=:activity LOV custom Y select distinct ca.activity value, ca.description from cst_activities ca where ca.organization_id is null or :$flex$.organization_code is null or ca.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by ca.activity US Activity 12 120 1=1 pha.segment1=:po_number Char US PO Number 13 130 1=1 decode(wt.pm_cost_collected,null,nvl2(wt.pm_cost_collector_group_id,'1','4'),'N','2','E','3')=xxen_util.lookup_code(:transferred_to_projects,'INV_YES_NO_ERROR_NA',700) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='INV_YES_NO_ERROR_NA' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) US Transferred to Projects 14 140 1=1 wt.transaction_type=to_number(xxen_util.lookup_code(:transaction_type,'WIP_TRANSACTION_TYPE',700)) LOV WIP Transaction Type E77C7835DAA40406E0530100007F2B67 Y select meaning value, description from mfg_lookups where lookup_type='WIP_TRANSACTION_TYPE' and enabled_flag='Y' order by meaning US Transaction Type 15 150 1=1 wt.transaction_type in (1,2,3,17) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N N US Include Variance Transactions Also list cost update, period close, job close and final completion variance transactions. 7A1C99C30BE8481692D202583A2D4A41 Resource Hours SYSADMIN 2 ASSEMBLY 4 DEPARTMENT 1 JOB 3 OPERATION_SEQ 8 QUANTITY 6 RESOURCE_CODE 5 RESOURCE_SEQ 7 UOM S Site