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.JE_ES_MODELO_EXT_PKG dependencies on HZ_PARTY_SITES

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 68: , hz_party_sites HPS

64: SUBSTR(HL.address_line_2,1,23) ||
65: LPAD(SUBSTR(HL.address_line_3,1,length(HL.address_line_3) -
66: NVL(LENGTH(LTRIM(TRANSLATE(HL.address_line_3, '123456789','000000000'),'0')),0)),5,'0') address_detail
67: FROM hz_cust_acct_sites_all HCAS
68: , hz_party_sites HPS
69: , hr_locations HL
70: , fnd_territories FT
71: , hz_cust_site_uses_all HCSU
72: WHERE HCAS.cust_acct_site_id = p_customer_address_id

Line 107: , hz_party_sites HPS

103: , SUBSTR(HL.address1,1,2) sigla
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

Line 162: , hz_party_sites HPS

158: , SUBSTR(HL.global_attribute5,1,2) global_attribute5
159: FROM jg_zz_vat_rep_status JZVRS
160: , jg_zz_vat_trx_details JZVTD
161: , hz_cust_acct_sites_all HCAS
162: , hz_party_sites HPS
163: , hr_locations HL
164: , fnd_territories FT
165: , hz_cust_site_uses_all HCSU
166: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 618: , hz_party_sites HPS

614: )
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

Line 651: --, hz_party_sites HPS

647: -- SUM(ROUND(NVL(JVGT.trx_line_amt,0), 2)) arrenda_amount
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