APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDOR_SITES_ALL

Line 1391: --Changed the query to go against po_vendor_sites_all

1387:
1388: begin
1389:
1390: --
1391: --Changed the query to go against po_vendor_sites_all
1392: --instead of po_supplier_sites_val_v.
1393: select 'Y',
1394: vendor_site_code
1395: into x_valid_vendor_site,

Line 1397: from po_vendor_sites_all

1393: select 'Y',
1394: vendor_site_code
1395: into x_valid_vendor_site,
1396: x_vendor_site
1397: from po_vendor_sites_all
1398: where vendor_id = x_vendor_id
1399: and vendor_site_id = x_suggested_vendor_site_id
1400: --
1401: and purchasing_site_flag = 'Y'

Line 7637: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

7633: l_item_id NUMBER;
7634: l_cons_from_supp_flag VARCHAR2(1);
7635: x_progress VARCHAR2 (300);
7636: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;
7637: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
7638:
7639: l_return_status VARCHAR2(1);
7640: l_msg_count NUMBER;
7641: l_msg_data VARCHAR2(2000);

Line 7803: FROM po_vendor_sites_all

7799: IF p_suggested_vendor_site_id IS NOT NULL THEN
7800: BEGIN
7801: SELECT org_id
7802: INTO l_purchasing_org_id
7803: FROM po_vendor_sites_all
7804: WHERE vendor_site_id = p_suggested_vendor_site_id;
7805: EXCEPTION
7806: WHEN NO_DATA_FOUND THEN
7807: l_purchasing_org_id := p_org_id;