APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_VENDORS

Line 922: -- Bug 5467617: Removed the joins to PO_VENDORS and PO_VENDOR_SITES_ALL

918: encumbrance_flag_rslt_tbl -- Bug 4723367
919: FROM po_req_split_lines_gt prs,
920: po_requisition_lines_all prl, --
921: financials_system_parameters fsp -- Bug 4723367
922: -- Bug 5467617: Removed the joins to PO_VENDORS and PO_VENDOR_SITES_ALL
923: -- These are not required anymore because they we used to fetch the
924: -- rounding rule from the site level. Now the tax rounding is done by
925: -- recalculating the tax at the end of this flow.
926: WHERE record_status in ('S','N')

Line 2176: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

2172: l_preparer_user_name varchar2(100);
2173: l_document_id po_headers.po_header_id%type;
2174: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
2175: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
2176: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
2177: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
2178: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
2179: l_vendor_site_code PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
2180:

Line 2177: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

2173: l_document_id po_headers.po_header_id%type;
2174: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
2175: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
2176: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
2177: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
2178: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
2179: l_vendor_site_code PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
2180:
2181: l_resp_id number;

Line 2248: FROM po_headers poh ,po_vendors pov,po_vendor_sites povs

2244: pov.vendor_name,
2245: poh.vendor_site_id,
2246: povs.vendor_site_code
2247: INTO l_vendor_id,l_vendor_name,l_vendor_site_id,l_vendor_site_code
2248: FROM po_headers poh ,po_vendors pov,po_vendor_sites povs
2249: WHERE po_header_id = l_document_id
2250: AND poh.vendor_id=pov.vendor_id
2251: AND poh.vendor_site_id=povs.vendor_site_id;
2252: