ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B940DF938EF940A5B5FA4C9A510BD218Y select mp.organization_code, wmt.transaction_date, 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, wmt.fm_operation_seq_num from_operation_seq, wmt.fm_operation_code from_operation_code, bd_fm.department_code from_department, xxen_util.meaning(wmt.fm_intraoperation_step_type,'WIP_INTRAOPERATION_STEP',700) from_step, wmt.to_operation_seq_num to_operation_seq, wmt.to_operation_code, bd_to.department_code to_department, xxen_util.meaning(wmt.to_intraoperation_step_type,'WIP_INTRAOPERATION_STEP',700) to_step, wmt.transaction_quantity quantity, wmt.transaction_uom uom, wmt.primary_quantity, wmt.primary_uom, wmt.overcompletion_transaction_qty overcompletion_quantity, wmt.overcompletion_primary_qty, xxen_util.concatenated_segments(wmt.scrap_account_id) scrap_account, mtr.reason_name reason, wmt.reference, nvl(papf.npw_number,papf.employee_number) employee_number, papf.full_name employee, wmt.source_code, xxen_util.user_name(wmt.created_by) created_by, wmt.creation_date, wmt.transaction_id from mtl_parameters mp, wip_move_transactions wmt, wip_entities we, wip_lines wl, mtl_system_items_vl msiv, bom_departments bd_fm, bom_departments bd_to, mtl_transaction_reasons mtr, per_all_people_f papf 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=wmt.organization_id and wmt.wip_entity_id=we.wip_entity_id and wmt.line_id=wl.line_id(+) and wmt.organization_id=wl.organization_id(+) and wmt.organization_id=msiv.organization_id(+) and wmt.primary_item_id=msiv.inventory_item_id(+) and wmt.fm_department_id=bd_fm.department_id and wmt.to_department_id=bd_to.department_id and wmt.reason_id=mtr.reason_id(+) and wmt.employee_id=papf.person_id(+) and wmt.transaction_date>=papf.effective_start_date(+) and wmt.transaction_date<papf.effective_end_date(+)+1 order by mp.organization_code, wmt.transaction_date, wmt.transaction_id Added the employee who performed the move (Employee Number, Employee columns and an Employee Number parameter). WIP :Date_From is not null or :Job is not null US WIP Move Transactions WIP move transactions of discrete jobs, lot based jobs, repetitive schedules and flow schedules, one row per transaction, as shown in the View Move Transactions form. The report covers the data of the Oracle standard Move Transaction Report (WIPTSMOV), with the from and to operation, department and intraoperation step, transaction and primary quantity, reason and reference, plus over-completion quantities, scrap account and the employee who performed the move. Quantity is in the unit of measure the transaction was entered in, Primary Quantity in the assembly's primary unit of measure. Transactions still pending in the move 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 wmt.transaction_date>=:date_from DateTime US Date From 3 30 1=1 wmt.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_fm.department_code=:from_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 From Department 8 80 1=1 bd_to.department_code=:to_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 To Department 9 90 1=1 wmt.fm_intraoperation_step_type=to_number(xxen_util.lookup_code(:from_step,'WIP_INTRAOPERATION_STEP',700)) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='WIP_INTRAOPERATION_STEP' 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 From Step 10 100 1=1 wmt.to_intraoperation_step_type=to_number(xxen_util.lookup_code(:to_step,'WIP_INTRAOPERATION_STEP',700)) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='WIP_INTRAOPERATION_STEP' 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 To Step 11 110 1=1 mtr.reason_name=:reason LOV custom Y select mtr.reason_name value, mtr.description||case when mtr.disable_date<sysdate then ' (inactive)' end description from mtl_transaction_reasons mtr order by mtr.reason_name US Reason 12 120 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