WIP Location

Description
Categories: BI Publisher
Imported from BI Publisher
Description: WIP Location Report
Application: Work in Process
Source: WIP Location Report (XML)
Short Name: WIPMTLCT_XML
DB package: WIP_WIPMTLCT_XMLP_PKG
Run WIP Location and other Oracle EBS reports with Blitz Report™ on our demo environment
select WE.wip_entity_name Job_Schedule,
                   WL.line_code Line,
                   DE.department_code Dept,
                   WO.operation_seq_num Seq,
                   SUM(round(WO.quantity_in_queue,:P_Qty_Precision)) Queue,
                   SUM(round(WO.quantity_running,:P_Qty_Precision)) Run,
                   SUM(round(WO.quantity_waiting_to_move,:P_Qty_Precision)) To_move,
                   SUM(round(WO.quantity_rejected,:P_Qty_Precision)) Rejected,
                   SUM(round(WO.quantity_scrapped,:P_Qty_Precision)) Scrapped,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Assembly
            from
                 mtl_system_items MSI,
                 wip_lines WL,
                 wip_repetitive_schedules WR,
                 wip_discrete_jobs DJ,
                 wip_operations WO,
                 bom_departments DE,
                 wip_entities WE
            where &P_FLEXWHERE
              and WO.organization_id = :P_Organization_Id
              and WE.organization_id = :P_Organization_Id
              and DE.organization_id = :P_Organization_Id
              and MSI.organization_id = WE.Organization_Id
              and WO.wip_entity_id = WE.wip_entity_id
              and WR.line_id = WL.line_id (+)
              and WR.organization_id = WL.organization_id (+)
              and WO.repetitive_schedule_id = WR.repetitive_schedule_id (+)
              and WE.primary_item_id = MSI.inventory_item_id
              and WO.wip_entity_id = WR.wip_entity_id (+)
              and WO.organization_id = WR.organization_id (+)
              and WO.wip_entity_id = DJ.wip_entity_id (+)
              and WO.organization_id = DJ.organization_id (+)
              and WE.entity_type in (1, 2)
              and (DJ.status_type in (3,4,6) OR WR.status_type in (3,4,6))
              and WO.department_id = DE.department_id
              and (WO.quantity_in_queue >0 OR
                       WO.quantity_running >0 OR
                       WO.quantity_waiting_to_move >0 OR
                       WO.quantity_rejected >0 OR
                       WO.quantity_scrapped >0)
              &Limit_Jobs
              &Limit_Lines
              &Limit_Assembly
              &Limit_Departments
            group by fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), WE.wip_entity_name, WL.line_code, DE.department_code,
                WO.operation_seq_num
            &C_Order1
            &C_ASSY_ORDER
            &C_Order2
Parameter Name SQL text Validation
Sort By
 
LOV Oracle
Jobs/Schedules From
 
LOV Oracle
To
 
LOV Oracle
Lines From
 
LOV Oracle
To 2
 
LOV Oracle
Assemblies From
 
Char
To 3
 
Char
Departments From
 
LOV Oracle
To 4
 
LOV Oracle
Blitz Report™