PO Buyer Listing

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source: Buyer Listing (XML)
Short Name: POXAGLST_XML
DB package: PO_POXAGLST_XMLP_PKG
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 NameSQL textValidation
P_STRUCT_NUM
 
Number
Sort By
 
LOV Oracle
Location
 
LOV Oracle
To
 
Categories From
 
Active/Inactive
 
LOV Oracle
Title