PO Backordered Internal Requisitions

Description
Categories: BI Publisher
Application: Purchasing
Source: Backordered Internal Requisitions Report (XML)
Short Name: POXRQOBO_XML
DB package: PO_POXRQOBO_XMLP_PKG
Run PO Backordered Internal Requisitions and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  prh.segment1                      Req_Number
,       prl.creation_date                 CDate
,       prl.line_num                      Line
,       prl.item_id                       Item_ID
,       prl.source_organization_id        Org_ID
,       null                      C_FLEX_ITEM
,       null                       C_FLEX_CAT
,       prl.item_description              Item_Description
,       papf.full_name                    Requestor
,       ood.organization_code             Organization
,       prl.source_subinventory           Subinventory
,       (prl.quantity - nvl(prl.quantity_cancelled,0))              Ordered_Quantity
,       round(SUM(&C_backordered),:P_qty_precision)                 Backordered
,       prl.unit_meas_lookup_code               		    Unit
,       round(SUM(&C_ship_quantity), :P_qty_precision) 		    Shipped
,       decode(psp1.manual_req_num_type,'NUMERIC',  
               null,prh.segment1)
,       decode(psp1.manual_req_num_type,'NUMERIC',
               to_number(prh.segment1),null), 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP
FROM    po_requisition_headers    prh
,       po_requisition_lines      prl
,       mtl_system_items          msi
,       per_all_people_f          papf
&C_from
,       mtl_categories                mca
,       org_organization_definitions  ood
,       po_system_parameters          psp1
WHERE   trunc(prl.creation_date) 
            BETWEEN nvl(:P_creation_date_from,trunc(prl.creation_date)-1) 
            AND     nvl(:P_creation_date_to,trunc(prl.creation_date)+1)
AND     papf.full_name = nvl(:P_requestor,papf.full_name)
AND     nvl(prl.source_subinventory,'-1') 
            BETWEEN nvl(:P_subinventory_from,  nvl(prl.source_subinventory,'-1')) 
            AND     nvl(:P_subinventory_to,nvl(prl.source_subinventory,'-1'))
AND     prl.requisition_header_id       = prh.requisition_header_id
AND     prl.source_type_code            = 'INVENTORY'
AND     nvl(prh.transferred_to_oe_flag,'N') = 'Y'
AND     prl.source_organization_id      = ood.organization_id
AND     papf.person_id              = prl.to_person_id
AND     msi.inventory_item_id       = prl.item_id
AND     msi.organization_id         = prl.source_organization_id 
AND     mca.category_id             = prl.category_id   
AND     trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
AND     decode(hr_general.get_xbg_profile,
                            'Y',papf.business_group_id,
                            hr_general.get_business_group_id)=papf.business_group_id
&C_where
GROUP BY prh.segment1
,        prl.creation_date                  
,        prl.line_num
,        prl.item_id
,        prl.source_organization_id         
,        fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')                      
,        fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')                        
,        prl.item_description                   
,        papf.full_name                      
,        ood.organization_code               
,        prl.source_subinventory    
,        &C_backordered             
,        prl.unit_meas_lookup_code 
,        &C_ship_quantity           
,        psp1.manual_req_num_type 
,       (prl.quantity - nvl(prl.quantity_cancelled,0)) 
ORDER BY decode(psp1.manual_req_num_type,'NUMERIC',
                null,prh.segment1)
,        decode(psp1.manual_req_num_type,'NUMERIC',
                to_number(prh.segment1), null)
,        prl.line_num
Parameter Name SQL text Validation
Title
 
Char
Creation Dates From
 
Date
To
 
Date
To
 
LOV Oracle
Requester
 
LOV Oracle
Subinventories From
 
LOV Oracle
Dynamic Precision Option
 
LOV Oracle
Blitz Report™