DBA Data[Home] [Help]

APPS.PO_VENDOR_SITES_SV dependencies on PO_VENDOR_SITES_ALL

Line 119: FROM po_vendor_sites_all

115: --SQL What: Query base table to validate vendor site ID
116: --SQL Why: Validate site in specified org_id
117: SELECT vendor_site_id
118: INTO l_vendor_site_id_v
119: FROM po_vendor_sites_all
120: WHERE vendor_site_id = p_vendor_site_id
121: AND org_id = p_org_id
122: AND SYSDATE < NVL(inactive_date, SYSDATE + 1)
123: AND purchasing_site_flag = 'Y'

Line 257: from po_vendor_sites_all --

253: freight_terms_lookup_code,
254: terms_id ,
255: invoice_currency_code,
256: shipping_control --
257: from po_vendor_sites_all --
258: where vendor_site_id = X_vendor_site_id;
259:
260: X_progress varchar2(3) := '';
261:

Line 580: FROM PO_VENDOR_SITES_ALL PVS --

576: */
577:
578: CURSOR C is
579: SELECT PVS.vendor_site_code
580: FROM PO_VENDOR_SITES_ALL PVS --
581: WHERE PVS.vendor_site_id = X_vendor_site_id;
582:
583: BEGIN
584:

Line 763: l_hold_all_payments_flag PO_VENDOR_SITES_ALL.hold_all_payments_flag%TYPE;

759: x_error_status OUT NOCOPY VARCHAR2,
760: x_error_message OUT NOCOPY VARCHAR2
761: )
762: IS
763: l_hold_all_payments_flag PO_VENDOR_SITES_ALL.hold_all_payments_flag%TYPE;
764: l_pay_site_flag PO_VENDOR_SITES_ALL.pay_site_flag%TYPE;
765: BEGIN
766: IF p_remit_to_site_id IS NULL THEN
767: x_error_status := 'E';

Line 764: l_pay_site_flag PO_VENDOR_SITES_ALL.pay_site_flag%TYPE;

760: x_error_message OUT NOCOPY VARCHAR2
761: )
762: IS
763: l_hold_all_payments_flag PO_VENDOR_SITES_ALL.hold_all_payments_flag%TYPE;
764: l_pay_site_flag PO_VENDOR_SITES_ALL.pay_site_flag%TYPE;
765: BEGIN
766: IF p_remit_to_site_id IS NULL THEN
767: x_error_status := 'E';
768: x_error_message := 'All blanks';

Line 1050: l_fax_area po_vendor_sites_all.fax_area_code%type;

1046: x_document_num OUT NOCOPY VARCHAR2,
1047: p_retrieve_only_flag IN VARCHAR2)
1048: IS
1049:
1050: l_fax_area po_vendor_sites_all.fax_area_code%type;
1051:
1052: l_faxnum varchar2(30); -- Need to change this also as part of bug 5765243
1053:
1054: l_party_site_id po_headers_all.vendor_site_id%type;

Line 1221: -- 3. po_vendor_sites_all

1217: -- of the Supplier Site defaults. Also, we default email/fax
1218: -- from 3 places, in order of priority:
1219: -- 1. po_headers_all
1220: -- 2. po_vendor_contacts (see Bug 4597324)
1221: -- 3. po_vendor_sites_all
1222:
1223: -- Bug 6625807 / 6526600
1224: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,
1225: -- pvs.vendor_site_id) condition so that following query returns

Line 1261: po_vendor_sites_all pvs,

1257: x_email_address,
1258: l_fax_area,
1259: l_faxnum
1260: from po_headers_all poh,
1261: po_vendor_sites_all pvs,
1262: po_vendor_contacts pvc
1263: where poh.vendor_site_id = pvs.vendor_site_id and
1264: poh.vendor_contact_id = pvc.vendor_contact_id (+) and
1265: poh.po_header_id = p_document_id and

Line 1285: -- 4597324), then po_vendor_sites_all.

1281:
1282: elsif (p_document_type = 'RELEASE') then
1283: begin
1284: -- We default email/fax from po_vendor_contacts (see Bug
1285: -- 4597324), then po_vendor_sites_all.
1286:
1287: -- Bug 6625807 / 6526600
1288: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,
1289: -- pvs.vendor_site_id) condition so that following query returns

Line 1305: po_vendor_sites_all pvs,

1301: x_email_address,
1302: l_fax_area,
1303: l_faxnum
1304: from po_headers_all poh,
1305: po_vendor_sites_all pvs,
1306: po_vendor_contacts pvc,
1307: po_releases por
1308: where poh.vendor_site_id = pvs.vendor_site_id and
1309: poh.vendor_contact_id = pvc.vendor_contact_id (+) and

Line 1421: from po_vendor_sites_all pvs,

1417: select phv.tp_header_id, nvl(etd.edi_flag,'N')
1418: into l_tp_header_id, l_edi_flag
1419: from
1420: (select pvs.tp_header_id, ph.authorization_status, ph.type_lookup_code
1421: from po_vendor_sites_all pvs,
1422: po_vendors pv,
1423: po_headers_all ph
1424: where ph.vendor_id = pv.vendor_id (+)
1425: and ph.vendor_site_id = pvs.vendor_site_id (+)

Line 1441: from po_vendor_sites_all pvs,

1437: select phv.tp_header_id, nvl(etd.edi_flag,'N')
1438: into l_tp_header_id, l_edi_flag
1439: from
1440: (select pvs.tp_header_id, pr.authorization_status
1441: from po_vendor_sites_all pvs,
1442: po_vendors pv,
1443: po_headers_all ph,
1444: po_releases_all pr
1445: where ph.vendor_id = pv.vendor_id (+)

Line 1502: FROM po_vendor_sites_all

1498: BEGIN
1499:
1500: SELECT org_id
1501: INTO x_org_id
1502: FROM po_vendor_sites_all
1503: WHERE vendor_site_id = p_vendor_site_id;
1504:
1505: return (x_org_id);
1506: