APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDOR_SITES_ALL

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

1186:
1187: begin
1188:
1189: --
1190: --Changed the query to go against po_vendor_sites_all
1191: --instead of po_supplier_sites_val_v.
1192: select 'Y',
1193: vendor_site_code
1194: into x_valid_vendor_site,

Line 1196: from po_vendor_sites_all

1192: select 'Y',
1193: vendor_site_code
1194: into x_valid_vendor_site,
1195: x_vendor_site
1196: from po_vendor_sites_all
1197: where vendor_id = x_vendor_id
1198: and vendor_site_id = x_suggested_vendor_site_id
1199: --
1200: and purchasing_site_flag = 'Y'

Line 7184: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

7180: l_item_id NUMBER;
7181: l_cons_from_supp_flag VARCHAR2(1);
7182: x_progress VARCHAR2 (300);
7183: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;
7184: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
7185:
7186: l_return_status VARCHAR2(1);
7187: l_msg_count NUMBER;
7188: l_msg_data VARCHAR2(2000);

Line 7350: FROM po_vendor_sites_all

7346: IF p_suggested_vendor_site_id IS NOT NULL THEN
7347: BEGIN
7348: SELECT org_id
7349: INTO l_purchasing_org_id
7350: FROM po_vendor_sites_all
7351: WHERE vendor_site_id = p_suggested_vendor_site_id;
7352: EXCEPTION
7353: WHEN NO_DATA_FOUND THEN
7354: l_purchasing_org_id := p_org_id;