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_SUPPLIER_SITES_ALL

Line 5001: FROM ap_supplier_sites_all

4997: AND asp.org_id = fsp.org_id;
4998: else
4999: SELECT accts_pay_code_combination_id
5000: INTO p_invoice_rec.accts_pay_code_combination_id
5001: FROM ap_supplier_sites_all
5002: WHERE vendor_id = p_invoice_rec.vendor_id
5003: AND vendor_site_id = p_invoice_rec.vendor_site_id;
5004: end if;
5005: exception

Line 7270: l_new_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

7266: Where location_code = p_ship_to_loc_code
7267: and nvl(ship_to_site_flag, 'N') = 'Y';
7268:
7269:
7270: l_new_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
7271: -- bug# 13398814 ends
7272:
7273: check_lines_failure EXCEPTION;
7274: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 8642: FROM ap_supplier_sites_all

8638: ELSE
8639: BEGIN
8640: SELECT ship_to_location_id
8641: INTO lg_ship_to_loc_id_site(p_invoice_rec.vendor_site_id)
8642: FROM ap_supplier_sites_all
8643: WHERE vendor_site_id = p_invoice_rec.vendor_site_id;
8644:
8645: p_invoice_lines_tab(i).ship_to_location_id:= lg_ship_to_loc_id_site(p_invoice_rec.vendor_site_id);
8646:

Line 21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

21799:
21800: --6412397
21801: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
21802: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
21806:
21807: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

Line 22032: FROM ap_supplier_sites_all

22028: ----------------------------------------------------------------------
22029: BEGIN
22030: SELECT location_id, ship_to_location_id, fob_lookup_code
22031: INTO l_location_id, l_ship_to_location_id, l_fob_point
22032: FROM ap_supplier_sites_all
22033: WHERE vendor_site_id = l_inv_hdr_vendor_site_id;
22034:
22035: EXCEPTION
22036: WHEN no_data_found THEN

Line 23093: from ap_supplier_sites_all

23089: where vendor_id = p_invoice_rec.remit_to_supplier_id;
23090:
23091: select party_site_id
23092: into l_remit_party_site_id
23093: from ap_supplier_sites_all
23094: where vendor_site_id = p_invoice_rec.remit_to_supplier_site_id
23095: and org_id = p_invoice_rec.org_id;
23096: --Bug 8213679
23097: ELSE

Line 23108: from ap_supplier_sites_all

23104: AND p_invoice_rec.invoice_type_lookup_code <> 'PAYMENT REQUEST'
23105: AND nvl(p_invoice_rec.vendor_site_id, -1) > 0 THEN
23106: select party_site_id
23107: into l_remit_party_site_id
23108: from ap_supplier_sites_all
23109: where vendor_site_id = p_invoice_rec.vendor_site_id
23110: and org_id = p_invoice_rec.org_id;
23111: ELSE
23112: l_remit_party_site_id := null;

Line 23710: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

23706: From hr_locations
23707: Where location_code = p_ship_to_loc_code
23708: and nvl(ship_to_site_flag, 'N') = 'Y';
23709:
23710: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
23711: current_calling_sequence VARCHAR2(2000);
23712: debug_info varchar2(1000);
23713: ship_to_location_code_failure EXCEPTION;
23714: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 24078: from ap_supplier_sites_all

24074: if(p_invoice_rec.remit_to_supplier_site_id IS NOT NULL) then
24075: BEGIN
24076: select vendor_site_id
24077: into l_remit_supplier_site_id
24078: from ap_supplier_sites_all
24079: where vendor_site_id = p_invoice_rec.remit_to_supplier_site_id
24080: and org_id = p_invoice_rec.org_id;
24081:
24082: EXCEPTION

Line 24113: from ap_supplier_sites_all

24109: BEGIN
24110: If (l_remit_supplier_site_id IS NOT NULL) then
24111: select vendor_site_code
24112: into l_remit_supplier_site
24113: from ap_supplier_sites_all
24114: where vendor_site_code = p_invoice_rec.remit_to_supplier_site
24115: and org_id = p_invoice_rec.org_id
24116: and vendor_site_id = p_invoice_rec.remit_to_supplier_site_id;
24117: elsif(l_remit_supplier_id IS NOT NULL) then

Line 24120: from ap_supplier_sites_all

24116: and vendor_site_id = p_invoice_rec.remit_to_supplier_site_id;
24117: elsif(l_remit_supplier_id IS NOT NULL) then
24118: select vendor_site_code
24119: into l_remit_supplier_site
24120: from ap_supplier_sites_all
24121: where vendor_site_code = p_invoice_rec.remit_to_supplier_site
24122: and org_id = p_invoice_rec.org_id
24123: and vendor_id = p_invoice_rec.remit_to_supplier_id;
24124: elsif(l_remit_supplier_num IS NOT NULL) then

Line 24127: from ap_supplier_sites_all a,

24123: and vendor_id = p_invoice_rec.remit_to_supplier_id;
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

Line 24136: from ap_supplier_sites_all a,

24132: and b.segment1 = p_invoice_rec.remit_to_supplier_num;
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

Line 24224: FROM ap_supplier_sites_all

24220:
24221: IF (p_invoice_rec.remit_to_supplier_site_id is null and p_invoice_rec.remit_to_supplier_site is not null) THEN
24222: SELECT vendor_site_id
24223: INTO l_remit_supplier_site_id
24224: FROM ap_supplier_sites_all
24225: WHERE org_id = p_invoice_rec.org_id
24226: AND vendor_site_code = p_invoice_rec.remit_to_supplier_site;
24227: END IF;
24228:

Line 24264: -- Added AND condition so as to Select data from ap_supplier_sites_all when

24260:
24261: IF (l_result = FND_API.G_TRUE) THEN
24262: IF (l_relationship_id <> -1) THEN -- bug 8345877
24263: -- Bug 7675510
24264: -- Added AND condition so as to Select data from ap_supplier_sites_all when
24265: -- l_remit_supplier_site_id is having a Positive value
24266: -- Negative value of l_remit_supplier_site_id does not have any data in ap_supplier_sites_all
24267: -- This negative value is assigned to p_invoice_rec.vendor_site_id in
24268: -- FUNCTION v_check_party_vendor earlier in this package

Line 24266: -- Negative value of l_remit_supplier_site_id does not have any data in ap_supplier_sites_all

24262: IF (l_relationship_id <> -1) THEN -- bug 8345877
24263: -- Bug 7675510
24264: -- Added AND condition so as to Select data from ap_supplier_sites_all when
24265: -- l_remit_supplier_site_id is having a Positive value
24266: -- Negative value of l_remit_supplier_site_id does not have any data in ap_supplier_sites_all
24267: -- This negative value is assigned to p_invoice_rec.vendor_site_id in
24268: -- FUNCTION v_check_party_vendor earlier in this package
24269:
24270: IF (l_remit_supplier_site_id is not null AND

Line 24275: FROM ap_supplier_sites_all

24271: l_remit_supplier_site_id > 0) THEN
24272: -- Bug 7675510 ends
24273: SELECT vendor_site_id, vendor_site_code
24274: INTO l_remit_supplier_site_id, l_remit_supplier_site
24275: FROM ap_supplier_sites_all
24276: WHERE vendor_site_id = l_remit_supplier_site_id
24277: and org_id = p_invoice_rec.org_id;
24278: END IF;
24279: