PO RFQ Action Required
Description
- Categories
- BI Publisher
- Application
- Purchasing
- Source
- RFQ Action Required Report (XML)
- Short Name
- POXRFRAR_XML
- DB package
- PO_POXRFRAR_XMLP_PKG
Imported from BI Publisher
RFQ Action Required Report
RFQ Action Required Report
SQL 43 lines
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) |
Parameters 10
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Title | Char | |
| Buyer Name | LOV Oracle | |
| RFQ Reply Date From | Date | |
| To | Date | |
| Vendors From | LOV Oracle | |
| To 2 | LOV Oracle | |
| Categories From | Char | |
| To 3 | Char | |
| Sort By | LOV Oracle |