PO Buyer Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Buyer Listing
Application: Purchasing
Source: Buyer Listing (XML)
Short Name: POXAGLST_XML
DB package: PO_POXAGLST_XMLP_PKG
Run PO Buyer Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   hre.full_name           buyer
,        null             C_FLEX_CAT
,        hrl.location_code       location
,        poa.start_date_active   start_date
,        poa.end_date_active     end_date, 
	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_agents               poa
,        hr_locations            hrl
,        hr_employees            hre
,        mtl_categories          mca
WHERE    poa.agent_id                     = hre.employee_id
AND      poa.category_id                  = mca.category_id (+)
AND      nvl(poa.location_id,-1)          = hrl.location_id (+)
AND      nvl(hrl.location_code,'~')       = 
         decode(:P_location, null, nvl(hrl.location_code,'~'), :P_location)
AND      ((:P_active_inactive = 'BOTH')
OR       (:P_active_inactive              = 'ACTIVE'
            AND sysdate   >= nvl(poa.start_date_active,sysdate - 1)
            AND sysdate   <  nvl(poa.end_date_active,sysdate + 1))
OR       (:P_active_inactive              = 'INACTIVE'
            AND (sysdate  <  nvl(poa.start_date_active,sysdate - 1)
            OR  sysdate   >= nvl(poa.end_date_active,sysdate + 1))))
AND      &P_WHERE_CAT
--ORDER BY &orderby_clause
ORDER BY &orderby_clause,hrl.location_code,poa.start_date_active,poa.end_date_active
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Title 
 
 Char
Active/Inactive 
 
 LOV Oracle
Categories From 
 
 Char
To 
 
 Char
Location 
 
 LOV Oracle
Sort By 
 
 LOV Oracle
Download
 
Related Blitz Reports
ECC Procurement, Purchase Orders INV Inventory Item Upload PO Purchase Order and Releases Detail PO Purchase Order Commitment By Period PO Item Summary Listing PO Item Detail Listing ECC Discrete Manufacturing, Resources ECC Process Manufacturing, Outside Processing Batch CAC PO Price vs. Costing Method Comparison
Blitz Report™

Blitz Report™ provides multiple benefits: