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 19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

19994:
19995: --6412397
19996: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
19997: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
20001:
20002: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

Line 20223: FROM ap_supplier_sites_all

20219: ----------------------------------------------------------------------
20220: BEGIN
20221: SELECT location_id, ship_to_location_id, fob_lookup_code
20222: INTO l_location_id, l_ship_to_location_id, l_fob_point
20223: FROM ap_supplier_sites_all
20224: WHERE vendor_site_id = l_inv_hdr_vendor_site_id;
20225:
20226: EXCEPTION
20227: WHEN no_data_found THEN

Line 21267: from ap_supplier_sites_all

21263: where vendor_id = p_invoice_rec.remit_to_supplier_id;
21264:
21265: select party_site_id
21266: into l_remit_party_site_id
21267: from ap_supplier_sites_all
21268: where vendor_site_id = p_invoice_rec.remit_to_supplier_site_id
21269: and org_id = p_invoice_rec.org_id;
21270: --Bug 8213679
21271: ELSE

Line 21730: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

21726: From hr_locations
21727: Where location_code = p_ship_to_loc_code
21728: and nvl(ship_to_site_flag, 'N') = 'Y';
21729:
21730: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21731: current_calling_sequence VARCHAR2(2000);
21732: debug_info varchar2(1000);
21733: ship_to_location_code_failure EXCEPTION;
21734: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 21929: from ap_supplier_sites_all

21925:
21926: if(p_invoice_rec.remit_to_supplier_site_id IS NOT NULL) then
21927: select vendor_site_id
21928: into l_remit_supplier_site_id
21929: from ap_supplier_sites_all
21930: where vendor_site_id = p_invoice_rec.remit_to_supplier_site_id
21931: and org_id = p_invoice_rec.org_id;
21932:
21933: If (l_remit_supplier_site_id is null) then

Line 21950: from ap_supplier_sites_all

21946: if(p_invoice_rec.remit_to_supplier_site IS NOT NULL) then
21947: If (l_remit_supplier_site_id IS NOT NULL) then
21948: select vendor_site_code
21949: into l_remit_supplier_site
21950: from ap_supplier_sites_all
21951: where vendor_site_code = p_invoice_rec.remit_to_supplier_site
21952: and org_id = p_invoice_rec.org_id
21953: and vendor_site_id = p_invoice_rec.remit_to_supplier_site_id;
21954: elsif(l_remit_supplier_id IS NOT NULL) then

Line 21957: from ap_supplier_sites_all

21953: and vendor_site_id = p_invoice_rec.remit_to_supplier_site_id;
21954: elsif(l_remit_supplier_id IS NOT NULL) then
21955: select vendor_site_code
21956: into l_remit_supplier_site
21957: from ap_supplier_sites_all
21958: where vendor_site_code = p_invoice_rec.remit_to_supplier_site
21959: and org_id = p_invoice_rec.org_id
21960: and vendor_id = p_invoice_rec.remit_to_supplier_id;
21961: elsif(l_remit_supplier_num IS NOT NULL) then

Line 21964: from ap_supplier_sites_all a,

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

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

22213:
22214: IF (l_result = FND_API.G_TRUE) THEN
22215:
22216: -- Bug 7675510
22217: -- Added AND condition so as to Select data from ap_supplier_sites_all when
22218: -- l_remit_supplier_site_id is having a Positive value
22219: -- Negative value of l_remit_supplier_site_id does not have any data in ap_supplier_sites_all
22220: -- This negative value is assigned to p_invoice_rec.vendor_site_id in
22221: -- FUNCTION v_check_party_vendor earlier in this package

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

22215:
22216: -- Bug 7675510
22217: -- Added AND condition so as to Select data from ap_supplier_sites_all when
22218: -- l_remit_supplier_site_id is having a Positive value
22219: -- Negative value of l_remit_supplier_site_id does not have any data in ap_supplier_sites_all
22220: -- This negative value is assigned to p_invoice_rec.vendor_site_id in
22221: -- FUNCTION v_check_party_vendor earlier in this package
22222:
22223: IF (l_remit_supplier_site_id is not null AND

Line 22228: FROM ap_supplier_sites_all

22224: l_remit_supplier_site_id > 0) THEN
22225: -- Bug 7675510 ends
22226: SELECT vendor_site_id, vendor_site_code
22227: INTO l_remit_supplier_site_id, l_remit_supplier_site
22228: FROM ap_supplier_sites_all
22229: WHERE vendor_site_id = l_remit_supplier_site_id
22230: and org_id = p_invoice_rec.org_id;
22231: END IF;
22232: