APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_LOCATIONS

Line 24: Cursor was wrongly refering to hz_party_sites_all and hz_locations as

20: IS
21:
22: /** author: brathod
23: Modified following cursor to refer ap_supplier_sites_all to retrieve supplier address.
24: Cursor was wrongly refering to hz_party_sites_all and hz_locations as
25: jg_zz_vat_trx_details.billing_tp_address_id (value passed in parameter p_party_site_id) is actually a
26: supplier_site_id and not party_site_id. Please refer bug#5031773
27: */
28: CURSOR c_get_address IS

Line 108: , hz_locations HL

104: , SUBSTR(HL.address2,1,25) via_publica
105: , SUBSTR(HL.address3||'Z',1,INSTR(HL.address3||'Z',
106: LTRIM(HL.address3||'Z','1234567890')) - 1) numero FROM hz_cust_acct_sites_all HCAS
107: , hz_party_sites HPS
108: , hz_locations HL
109: , fnd_territories FT
110: , hz_cust_site_uses_all HCSU
111: WHERE HCAS.cust_acct_site_id = p_customer_address_id
112: AND HPS.party_site_id = HCAS.party_site_id

Line 619: , hz_locations HL

615: INTO V_PREPAY_APPLIED
616: FROM JG_ZZ_VAT_TRX_GT JVGT
617: , hz_cust_acct_sites_all HCAS
618: , hz_party_sites HPS
619: , hz_locations HL
620: , fnd_territories FT
621: , hz_cust_site_uses_all HCSU
622: WHERE JVGT.jg_info_n3 = p_customer_id
623: AND HCAS.cust_acct_site_id = JVGT.jg_info_n2

Line 652: --, hz_locations HL

648: INTO V_PREPAY_APPLIED
649: FROM JG_ZZ_VAT_TRX_DETAILS JVGT, JG_ZZ_VAT_REP_STATUS JZVRS
650: --, hz_cust_acct_sites_all HCAS
651: --, hz_party_sites HPS
652: --, hz_locations HL
653: --, fnd_territories FT
654: , hz_cust_site_uses_all HCSU
655: WHERE JVGT.billing_trading_partner_id = p_customer_id
656: --AND HCAS.cust_acct_site_id = JVGT.billing_tp_address_id

Line 960: lc_address4 hz_locations.address4%TYPE;

956: lc_country hr_locations.country%TYPE;
957: lc_address1 hr_locations.address_line_1%TYPE;
958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;
961: lc_city hr_locations.town_or_city%TYPE;
962: lc_postal_code hr_locations.postal_code%TYPE;
963: lc_contact hz_parties.party_name%TYPE;
964: lc_phone_number hz_contact_points.phone_number%TYPE;