WIP Location

Description
Categories: BI Publisher
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
Sort By
 
LOV Oracle
Jobs/Schedules From
 
LOV Oracle
To
 
LOV Oracle
Lines From
 
LOV Oracle
To
 
LOV Oracle
Assemblies From
 
Char
To
 
Char
Departments From
 
LOV Oracle
To
 
LOV Oracle
Flex structure number
 
Number
Organization Id
 
Number
Quantity Precision
 
Number