APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_VENDOR_SITES

Line 730: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468

726: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;
727: l_autoapprove_retro VARCHAR2(1);
728: l_okc_doc_type VARCHAR2(20); --
729: l_vendor po_vendors.vendor_name%type; --Bug 4254468
730: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
731: l_new_vendor po_vendors.vendor_name%type; --multi-mod
732: l_new_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --multi-mod
733: l_multi_mod_req_id PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID%TYPE; -- multi-mod
734: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE; --multi-mod

Line 732: l_new_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --multi-mod

728: l_okc_doc_type VARCHAR2(20); --
729: l_vendor po_vendors.vendor_name%type; --Bug 4254468
730: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
731: l_new_vendor po_vendors.vendor_name%type; --multi-mod
732: l_new_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --multi-mod
733: l_multi_mod_req_id PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID%TYPE; -- multi-mod
734: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE; --multi-mod
735: l_supplier_change_note varchar2(320); --multi-mod
736: l_supplier_site_change_note varchar2(320); --multi-mod

Line 952: po_vendor_sites_all pvs

948: SELECT pov.vendor_name, pvs.vendor_site_code
949: INTO l_vendor, l_vendor_site_code
950: FROM po_vendors pov,
951: po_headers poh,
952: po_vendor_sites_all pvs
953: WHERE pov.vendor_id = poh.vendor_id
954: AND poh.po_header_id = DocumentId
955: AND poh.vendor_site_id = pvs.vendor_site_id;
956:

Line 976: po_vendor_sites_all pvs

972: SELECT pv.vendor_name, pvs.vendor_site_code
973: INTO l_new_vendor, l_new_vendor_site_code
974: FROM po_headers_draft_all phda,
975: po_vendors pv,
976: po_vendor_sites_all pvs
977: WHERE draft_id = DraftID
978: AND phda.vendor_id = pv.vendor_id
979: AND phda.vendor_site_id = pvs.vendor_site_id;
980:

Line 1472: po_vendor_sites_all pvs

1468: INTO l_vendor,
1469: l_vendor_site_code
1470: FROM po_vendors pov,
1471: po_headers poh,
1472: po_vendor_sites_all pvs
1473: WHERE pov.vendor_id = poh.vendor_id
1474: AND poh.po_header_id = DocumentId
1475: AND poh.vendor_site_id = pvs.vendor_site_id;
1476: ELSE

Line 1484: po_vendor_sites_all pvs

1480: l_vendor_site_code
1481: FROM po_releases por,
1482: po_headers poh,
1483: po_vendors pov,
1484: po_vendor_sites_all pvs
1485: WHERE por.po_release_id = DocumentId
1486: AND por.po_header_id = poh.po_header_id
1487: AND poh.vendor_id = pov.vendor_id
1488: AND poh.vendor_site_id = pvs.vendor_site_id;

Line 3881: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;

3877: l_po_header_id NUMBER;
3878: l_vendor_site_code VARCHAR2(15);
3879: l_vendor_site_id NUMBER;
3880: --EMAILPO FPH START--
3881: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
3882: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
3883: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
3884: --EMAILPO FPH START--
3885: /* Bug 2989951 Increased the width of the following variables */

Line 3921: * sql query which selecs vendor_site_id below from po_vendor_sites

3917: RETURN;
3918: END IF;
3919: /* Bug 2687751.
3920: * For blankets, the org context was not getting set and hence
3921: * sql query which selecs vendor_site_id below from po_vendor_sites
3922: * was throwing an exception. Hence setting the org context here.
3923: */
3924: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
3925: IF l_orgid IS NOT NULL THEN

Line 3963: po_vendor_sites pvs, po_vendors pv

3959: INTO l_vendor_site_id,
3960: l_vendor_site_code,
3961: l_vendor_site_lang, l_vendor_name
3962: FROM po_headers poh,
3963: po_vendor_sites pvs, po_vendors pv
3964: WHERE pvs.vendor_site_id = poh.vendor_site_id
3965: AND pv.vendor_id = poh.vendor_id
3966: AND poh.po_header_id = l_po_header_id;
3967: --ER 5688144: End