WIP Location

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: WIP Location Report (XML)
Short Name: WIPMTLCT_XML
DB package: WIP_WIPMTLCT_XMLP_PKG
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
Quantity Precision
 
Number
Organization Id
 
Number
Flex structure number
 
Number
To
 
LOV Oracle
Departments From
 
LOV Oracle
To
 
Assemblies From
 
To
 
LOV Oracle
Lines From
 
LOV Oracle
To
 
LOV Oracle
Jobs/Schedules From
 
LOV Oracle
Sort By
 
LOV Oracle