APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 67: FROM hz_cust_acct_sites_all HCAS

63: , SUBSTR(HL.address_line_1,1,2) ||
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

Line 106: LTRIM(HL.address3||'Z','1234567890')) - 1) numero FROM hz_cust_acct_sites_all HCAS

102: , SUBSTR(HL.city,1,24) ref_catastral
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

Line 161: , hz_cust_acct_sites_all HCAS

157: , SUBSTR(HL.global_attribute4,1,2) global_attribute4
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

Line 617: , hz_cust_acct_sites_all HCAS

613: , g_cur_precision)
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

Line 650: --, hz_cust_acct_sites_all HCAS

646: + SUM(ROUND( NVL(JVGT.tax_amt_funcl_curr,JVGT.tax_amt ) , 2) ) arrenda_amount
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

Line 1992: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );

1988:
1989: lc_jgzz_modelo_query :=
1990: REPLACE( lc_jgzz_modelo_query
1991: , '$MODELO_TABLE_LIST$'
1992: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );
1993:
1994:
1995: lc_jgzz_modelo_query :=
1996: REPLACE( lc_jgzz_modelo_query

Line 2061: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );

2057:
2058: lc_jgzz_modelo_query :=
2059: REPLACE( lc_jgzz_modelo_query
2060: , '$MODELO_TABLE_LIST$'
2061: ,', hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca ' );
2062:
2063:
2064: lc_jgzz_modelo_query :=
2065: REPLACE( lc_jgzz_modelo_query