eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_SUPPLIERS

Line 23088: from ap_suppliers

23084: )THEN
23085: --Bug 8213679
23086: select party_id
23087: into l_remit_party_id
23088: from ap_suppliers
23089: where vendor_id = p_invoice_rec.remit_to_supplier_id;
23090:
23091: select party_site_id
23092: into l_remit_party_site_id

Line 23252: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%type ;

23248: current_calling_sequence VARCHAR2(2000);
23249: vendor_party_failure exception;
23250:
23251: -- Bug 7871425.
23252: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%type ;
23253:
23254: begin
23255:
23256: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_party_vendor<-'

Line 23346: from ap_suppliers where vendor_id = p_invoice_rec.vendor_id ;

23342: IF (nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') = 'EXPENSE REPORT'
23343: AND p_invoice_rec.party_site_id is null) THEN
23344:
23345: select vendor_type_lookup_code into l_vendor_type_lookup_code
23346: from ap_suppliers where vendor_id = p_invoice_rec.vendor_id ;
23347:
23348: END IF ;
23349:
23350: -- Bug 7871425.

Line 23849: from ap_suppliers

23845: If(p_invoice_rec.remit_to_supplier_name IS NOT NULL) then
23846: BEGIN
23847: select vendor_name
23848: into l_remit_supplier_name
23849: from ap_suppliers
23850: where vendor_name = p_invoice_rec.remit_to_supplier_name
23851: -- bug 8504185
23852: AND nvl(trunc(START_DATE_ACTIVE),
23853: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)

Line 23897: from ap_suppliers

23893: if(p_invoice_rec.remit_to_supplier_id IS NOT NULL) then
23894: BEGIN
23895: select vendor_id
23896: into l_remit_supplier_id
23897: from ap_suppliers
23898: where vendor_id = p_invoice_rec.remit_to_supplier_id
23899: -- bug 8504185
23900: AND nvl(trunc(START_DATE_ACTIVE),
23901: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)

Line 23937: from ap_suppliers

23933: if(p_invoice_rec.remit_to_supplier_num IS NOT NULL) then
23934: BEGIN
23935: select segment1
23936: into l_remit_supplier_num
23937: from ap_suppliers
23938: where segment1= p_invoice_rec.remit_to_supplier_num -- bug 7836976
23939: -- bug 8504185
23940: AND nvl(trunc(START_DATE_ACTIVE),
23941: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)

Line 23980: l_sql_stmt := ' SELECT party_id FROM ap_suppliers ' ||

23976: p_invoice_rec.remit_to_supplier_name is NULL and
23977: p_invoice_rec.remit_to_supplier_num is NULL) THEN
23978:
23979: /* Added for bug#9852174 Start */
23980: l_sql_stmt := ' SELECT party_id FROM ap_suppliers ' ||
23981: ' WHERE nvl(trunc(START_DATE_ACTIVE), :p_inv_sysdate ) <= :p_inv_sysdate'||
23982: ' AND nvl(trunc(END_DATE_ACTIVE),:p_inv_sysdate +1) > :p_inv_sysdate';
23983:
23984: IF p_invoice_rec.remit_to_supplier_id IS NOT NULL

Line 24040: FROM ap_suppliers

24036: /* Commented for bug#9852174 Start
24037: -- bug 8504185
24038: SELECT party_id
24039: INTO l_remit_party_id
24040: FROM ap_suppliers
24041: WHERE vendor_id = nvl(p_invoice_rec.remit_to_supplier_id,vendor_id)
24042: AND vendor_name = nvl(p_invoice_rec.remit_to_supplier_name,vendor_name)
24043: AND SEGMENT1 = nvl(p_invoice_rec.remit_to_supplier_num,SEGMENT1)
24044: -- bug 8504185

Line 24128: ap_suppliers b

24124: elsif(l_remit_supplier_num IS NOT NULL) then
24125: select a.vendor_site_code
24126: into l_remit_supplier_site
24127: from ap_supplier_sites_all a,
24128: ap_suppliers b
24129: where a.vendor_site_code = p_invoice_rec.remit_to_supplier_site
24130: and a.org_id = p_invoice_rec.org_id
24131: and a.vendor_id = b.vendor_id
24132: and b.segment1 = p_invoice_rec.remit_to_supplier_num;

Line 24137: ap_suppliers b

24133: elsif(l_remit_supplier_name IS NOT NULL) then
24134: select a.vendor_site_code
24135: into l_remit_supplier_site
24136: from ap_supplier_sites_all a,
24137: ap_suppliers b
24138: where a.vendor_site_code = p_invoice_rec.remit_to_supplier_site
24139: and a.org_id = p_invoice_rec.org_id
24140: and a.vendor_id = b.vendor_id
24141: and b.vendor_name = p_invoice_rec.remit_to_supplier_name;

Line 24190: FROM ap_suppliers

24186: /* commented below code as part of bug 8504185
24187: IF (p_invoice_rec.remit_to_supplier_id is not null and p_invoice_rec.remit_to_supplier_id > 0) THEN
24188: SELECT party_id
24189: INTO l_remit_party_id
24190: FROM ap_suppliers
24191: WHERE vendor_id = p_invoice_rec.remit_to_supplier_id
24192: -- bug 8504185
24193: AND nvl(trunc(START_DATE_ACTIVE),
24194: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)

Line 24203: FROM ap_suppliers

24199: ELS*/IF (p_invoice_rec.remit_to_supplier_name is not null) THEN
24200: BEGIN
24201: SELECT party_id
24202: INTO l_remit_party_id
24203: FROM ap_suppliers
24204: WHERE vendor_name = p_invoice_rec.remit_to_supplier_name
24205: -- bug 8504185
24206: AND nvl(trunc(START_DATE_ACTIVE),
24207: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)

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

24288:
24289: -- Bug 7675510
24290: -- Added the invoice_type_lookup_code condition to populate the l_remit_supplier_id,
24291: -- l_remit_supplier_name, l_remit_supplier_num from HZ_PARTIES table in case of PAYMENT REQUEST
24292: -- since the data is not available in AP_SUPPLIERS table for PAYMENT REQUEST type
24293:
24294:
24295: -- commented below IF part as part of bug 8345877.
24296: -- After TPP re-modelling, remit to supplier fields need not be populated.

Line 24323: FROM ap_suppliers

24319: -- bug 7629217 starts- dcshanmu - changed l_party_id to l_remit_party_id
24320: IF (l_remit_party_id is not null) THEN
24321: SELECT vendor_id, vendor_name, segment1
24322: INTO l_remit_supplier_id, l_remit_supplier_name, l_remit_supplier_num
24323: FROM ap_suppliers
24324: WHERE party_id = l_remit_party_id;
24325: END IF;
24326: -- bug 7629217 starts- dcshanmu ends
24327: