ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E425073FC65346F68A37DE6BC548454FY select mp.organization_code, wmt.transaction_date, trunc(wmt.transaction_date) transaction_day, we.wip_entity_name job, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) job_type, wl.line_code line, wrs.first_unit_start_date schedule_start_date, 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, nvl(wmta.transaction_quantity,wmt.transaction_quantity) quantity, wmt.transaction_uom uom, nvl(wmta.primary_quantity,wmt.primary_quantity) primary_quantity, wmt.primary_uom, xxen_util.yes(case when wmt.overcompletion_transaction_id is not null then 'Y' end) overcompletion, 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, 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_move_txn_allocations wmta, wip_repetitive_schedules wrs, wip_entities we, wip_lines wl, mtl_system_items_vl msiv, bom_departments bd_fm, bom_departments bd_to, mtl_transaction_reasons mtr 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.transaction_id=wmta.transaction_id(+) and wmta.repetitive_schedule_id=wrs.repetitive_schedule_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(+) order by mp.organization_code, wmt.transaction_date, wmt.transaction_id, wrs.first_unit_start_date Repetitive moves split by schedule with the allocated quantities, new columns Transaction Day, Schedule Start Date and Overcompletion, templates Move Throughput by Department and Scrap and Reject Moves. WIP :Date_From is not null or :Job is not null US WIP Move Transactions 11i 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): from and to operation, department and intraoperation step, transaction and primary quantity, reason and reference, over-completion and scrap account. A repetitive move is shown once per repetitive schedule it was allocated to, with the schedule's first unit start date and the allocated quantity. Quantity is in the unit of measure the transaction was entered in, Primary Quantity in the assembly's primary unit of measure. Transaction Day is the transaction date without the time, for daily totals. 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 trunc(sysdate)-30 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 CB19E6D0A33A470D948B1B828ED2ED8E Move Throughput by Department Daily shop floor throughput: primary quantity moved into each department per transaction day for the Date From and Date To range, as a pivot of to department by day, with filters for organization, to step and assembly. ENGINATICS 10 ASSEMBLY 6 FROM_DEPARTMENT 7 FROM_OPERATION_SEQ 8 FROM_STEP 9 JOB 1 ORGANIZATION_CODE 11 PRIMARY_QUANTITY 12 PRIMARY_UOM 3 TO_DEPARTMENT 2 4 TO_OPERATION_SEQ 5 TO_STEP 2 TRANSACTION_DAY 1 ASSEMBLY FILTER 3 ORGANIZATION_CODE FILTER 1 PRIMARY_QUANTITY VALUE 1 SUM TO_DEPARTMENT ROW 1 TO_STEP FILTER 2 TRANSACTION_DAY COLUMN 1 S Site 514FD384769A41A3B9D31CE77AF95FC7 Scrap and Reject Moves Moves to the Scrap and Reject intraoperation steps by transaction date, with job, assembly, operation, department, quantity, reason and scrap account, to review scrap and rejected quantities and their causes. ENGINATICS 4 ASSEMBLY 5 ASSEMBLY_DESCRIPTION 3 JOB 2 ORGANIZATION_CODE 10 PRIMARY_QUANTITY 11 PRIMARY_UOM 12 REASON 13 REFERENCE 14 SCRAP_ACCOUNT 8 TO_DEPARTMENT 7 TO_OPERATION_CODE 6 TO_OPERATION_SEQ 9 TO_STEP 1 TRANSACTION_DATE 1 To Step <multiple_values>Scrap;Reject S Site