APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_SUPPLIERS

Line 21262: from ap_suppliers

21258: IF p_invoice_rec.invoice_type_lookup_code <> 'PAYMENT REQUEST' THEN
21259: --Bug 8213679
21260: select party_id
21261: into l_remit_party_id
21262: from ap_suppliers
21263: where vendor_id = p_invoice_rec.remit_to_supplier_id;
21264:
21265: select party_site_id
21266: into l_remit_party_site_id

Line 21872: from ap_suppliers

21868:
21869: If(p_invoice_rec.remit_to_supplier_name IS NOT NULL) then
21870: select vendor_name
21871: into l_remit_supplier_name
21872: from ap_suppliers
21873: where vendor_name = p_invoice_rec.remit_to_supplier_name;
21874:
21875: If (l_remit_supplier_name is null) then
21876: l_remit_supplier_name_flag := 'F';

Line 21891: from ap_suppliers

21887:
21888: if(p_invoice_rec.remit_to_supplier_id IS NOT NULL) then
21889: select vendor_id
21890: into l_remit_supplier_id
21891: from ap_suppliers
21892: where vendor_id = p_invoice_rec.remit_to_supplier_id;
21893:
21894: If (l_remit_supplier_id is null) then
21895: l_remit_supplier_id_flag := 'F';

Line 21910: from ap_suppliers

21906:
21907: if(p_invoice_rec.remit_to_supplier_num IS NOT NULL) then
21908: select segment1
21909: into l_remit_supplier_num
21910: from ap_suppliers
21911: where segment1= p_invoice_rec.remit_to_supplier_num; -- bug 7836976
21912:
21913: If (l_remit_supplier_num is null) then
21914: l_remit_supplier_num_flag := 'F';

Line 21965: ap_suppliers b

21961: elsif(l_remit_supplier_num IS NOT NULL) then
21962: select a.vendor_site_code
21963: into l_remit_supplier_site
21964: from ap_supplier_sites_all a,
21965: ap_suppliers b
21966: where a.vendor_site_code = p_invoice_rec.remit_to_supplier_site
21967: and a.org_id = p_invoice_rec.org_id
21968: and a.vendor_id = b.vendor_id
21969: and b.segment1 = p_invoice_rec.remit_to_supplier_num;

Line 22115: FROM ap_suppliers

22111:
22112: IF (p_invoice_rec.party_id is null AND p_invoice_rec.vendor_id is not null) THEN
22113: SELECT party_id
22114: INTO l_party_id
22115: FROM ap_suppliers
22116: WHERE vendor_id = p_invoice_rec.vendor_id;
22117: ELSIF (p_invoice_rec.party_id is null AND p_invoice_rec.vendor_num is not null) THEN
22118: SELECT party_id
22119: INTO l_party_id

Line 22120: FROM ap_suppliers

22116: WHERE vendor_id = p_invoice_rec.vendor_id;
22117: ELSIF (p_invoice_rec.party_id is null AND p_invoice_rec.vendor_num is not null) THEN
22118: SELECT party_id
22119: INTO l_party_id
22120: FROM ap_suppliers
22121: WHERE segment1 = p_invoice_rec.vendor_num;
22122: ELSIF (p_invoice_rec.party_id is null AND p_invoice_rec.vendor_name is not null) THEN
22123: SELECT party_id
22124: INTO l_party_id

Line 22125: FROM ap_suppliers

22121: WHERE segment1 = p_invoice_rec.vendor_num;
22122: ELSIF (p_invoice_rec.party_id is null AND p_invoice_rec.vendor_name is not null) THEN
22123: SELECT party_id
22124: INTO l_party_id
22125: FROM ap_suppliers
22126: WHERE vendor_name = p_invoice_rec.vendor_name;
22127: ELSIF (p_invoice_rec.party_id is not null) THEN
22128: l_party_id := p_invoice_rec.party_id;
22129: END IF;

Line 22174: FROM ap_suppliers

22170:
22171: IF (p_invoice_rec.remit_to_supplier_id is not null) THEN
22172: SELECT party_id
22173: INTO l_remit_party_id
22174: FROM ap_suppliers
22175: WHERE vendor_id = p_invoice_rec.remit_to_supplier_id;
22176: END IF;
22177:
22178: -------------------------------------------------------------------

Line 22255: -- since the data is not available in AP_SUPPLIERS table for PAYMENT REQUEST type

22251:
22252: -- Bug 7675510
22253: -- Added the invoice_type_lookup_code condition to populate the l_remit_supplier_id,
22254: -- l_remit_supplier_name, l_remit_supplier_num from HZ_PARTIES table in case of PAYMENT REQUEST
22255: -- since the data is not available in AP_SUPPLIERS table for PAYMENT REQUEST type
22256:
22257: -------------------------------------------------------------------
22258: debug_info := 'Invoice Type Lookup Code '||p_invoice_rec.invoice_type_lookup_code;
22259: -------------------------------------------------------------------

Line 22283: FROM ap_suppliers

22279: -- bug 7629217 starts- dcshanmu - changed l_party_id to l_remit_party_id
22280: IF (l_remit_party_id is not null) THEN
22281: SELECT vendor_id, vendor_name, segment1
22282: INTO l_remit_supplier_id, l_remit_supplier_name, l_remit_supplier_num
22283: FROM ap_suppliers
22284: WHERE party_id = l_remit_party_id;
22285: END IF;
22286: -- bug 7629217 starts- dcshanmu ends
22287: