APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDOR_SITES

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 5287: * PO_VENDOR_SITES_SV.Get_Transmission_Defaults which does this now.

5283: * Deleted the code which gets teh preparer_id if it is null since
5284: * x_preparer_id will be derived in get_transmission_defaults if
5285: * this is null. Also deleted the code which gets the default supplier
5286: * communication method from po_vendor_site and now call
5287: * PO_VENDOR_SITES_SV.Get_Transmission_Defaults which does this now.
5288: * Also deleted the code which defaults item_type, item_key from
5289: * po_document_types as this is done now in start_wf_process.
5290: */
5291:

Line 5320: po_vendor_sites pvs,

5316: into l_tp_header_id,
5317: l_edi_flag,
5318: x_preparer_id
5319: from ece_tp_details etd,
5320: po_vendor_sites pvs,
5321: po_vendors pv,
5322: po_headers ph
5323: where pv.vendor_id = pvs.vendor_id
5324: and pvs.tp_header_id = etd.tp_header_id

Line 5348: po_vendor_sites pvs,

5344: into l_tp_header_id,
5345: l_edi_flag,
5346: x_preparer_id
5347: from ece_tp_details etd,
5348: po_vendor_sites pvs,
5349: po_vendors pv,
5350: po_headers ph ,
5351: po_releases pr
5352: where pv.vendor_id = pvs.vendor_id

Line 5384: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(

5380: else
5381: /* bug 4638656 - end */
5382:
5383:
5384: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(
5385: p_document_id => x_doc_id,
5386: p_document_type => x_doc_type,
5387: p_document_subtype => x_doc_subtype,
5388: p_preparer_id => x_preparer_id,

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;