APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_VENDORS

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

991: encumbrance_flag_rslt_tbl -- Bug 4723367
992: FROM po_req_split_lines_gt prs,
993: po_requisition_lines_all prl, --
994: financials_system_parameters fsp -- Bug 4723367
995: -- Bug 5467617: Removed the joins to PO_VENDORS and PO_VENDOR_SITES_ALL
996: -- These are not required anymore because they we used to fetch the
997: -- rounding rule from the site level. Now the tax rounding is done by
998: -- recalculating the tax at the end of this flow.
999: WHERE record_status in ('S','N')

Line 2257: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

2253: l_preparer_user_name varchar2(100);
2254: l_document_id po_headers.po_header_id%type;
2255: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
2256: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
2257: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
2258: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
2259: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
2260: l_vendor_site_code PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
2261:

Line 2258: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

2254: l_document_id po_headers.po_header_id%type;
2255: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
2256: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
2257: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
2258: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
2259: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
2260: l_vendor_site_code PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
2261:
2262: l_resp_id number;

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

2325: pov.vendor_name,
2326: poh.vendor_site_id,
2327: povs.vendor_site_code
2328: INTO l_vendor_id,l_vendor_name,l_vendor_site_id,l_vendor_site_code
2329: FROM po_headers poh ,po_vendors pov,po_vendor_sites povs
2330: WHERE po_header_id = l_document_id
2331: AND poh.vendor_id=pov.vendor_id
2332: AND poh.vendor_site_id=povs.vendor_site_id;
2333: