PO RFQ Action Required

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source: RFQ Action Required Report (XML)
Short Name: POXRFRAR_XML
DB package: PO_POXRFRAR_XMLP_PKG
SELECT papf.full_name         Buyer
,      poh.segment1          RFQ_Number
,      poh.reply_date        Reply_Due_Date
,      poh.comments          Description
,      poh.po_header_id
FROM   per_all_people_f          papf
,      po_rfq_vendors        prv
,      po_headers            poh
,      po_lines              pol
,      po_vendors            pov
,      mtl_categories        mca
WHERE  poh.type_lookup_code        = 'RFQ'
       and poh.po_header_id        = prv.po_header_id
       and poh.po_header_id        = pol.po_header_id
       and pol.category_id         = mca.category_id
       and pov.vendor_id           = prv.vendor_id
       and poh.agent_id            = papf.person_id
       and PAPF.BUSINESS_GROUP_ID = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID),0) 
FROM FINANCIALS_SYSTEM_PARAMETERS FSP) 
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', 
HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F',PAPF.PERSON_ID, PAPF.PERSON_TYPE_ID,
PAPF.EMPLOYEE_NUMBER,PAPF.APPLICANT_NUMBER 
,PAPF.NPW_NUMBER)) = 'TRUE'      
AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', PAPF.BUSINESS_GROUP_ID ,
HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID
       and poh.status_lookup_code != 'C'
      and (nvl(poh.reply_date, decode(:P_date_from,null,sysdate,:P_date_from -1))
               >= nvl(:P_date_from,nvl(poh.reply_date,sysdate-1)))
       and (nvl(poh.reply_date,decode(:P_date_to,null,sysdate,:P_date_to + 1))
                <= nvl(:P_date_to,nvl(poh.reply_date,sysdate+1)))
      and pov.vendor_name BETWEEN nvl(:P_vendor_from,pov.vendor_name)
                           AND     nvl(:P_vendor_to,pov.vendor_name)
       and papf.full_name    = nvl(:P_buyer,papf.full_name)
       and not exists (select 'x'
                       from po_headers quote
                       where poh.po_header_id=quote.from_header_id
                         and prv.vendor_site_id=quote.vendor_site_id)
AND    &P_WHERE_CAT 
GROUP BY papf.full_name, poh.segment1, poh.reply_date, poh.comments, poh.po_header_id
ORDER BY decode(:P_ORDERBY,'RFQ REPLY DATE', poh.reply_date) 
,                    decode(:P_ORDERBY,'BUYER', papf.full_name,papf.full_name)
Parameter Name SQL text Validation
P_STRUCT_NUM
 
Number
Sort By
 
LOV Oracle
To
 
Categories From
 
To
 
LOV Oracle
Vendors From
 
LOV Oracle
To
 
Date
RFQ Reply Date From
 
Date
Buyer Name
 
LOV Oracle
Title