APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 291: , hz_cust_accounts hzca

287: FROM jg_zz_vat_rep_status JZVRS
288: , jg_zz_vat_trx_details JZVTD
289: , hz_cust_site_uses_all hzcsu
290: , hz_cust_acct_sites_all hzcas
291: , hz_cust_accounts hzca
292: , ra_customer_trx_all trx
293: , zx_lines_det_factors zxdf
294:
295: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 3489: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ra_customer_trx_all trx, zx_lines_det_factors zxdf ');

3485:
3486: lc_jgzz_modelo_query :=
3487: REPLACE( lc_jgzz_modelo_query
3488: , '$MODELO_TABLE_LIST$'
3489: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ra_customer_trx_all trx, zx_lines_det_factors zxdf ');
3490:
3491: lc_jgzz_modelo_query :=
3492: REPLACE( lc_jgzz_modelo_query
3493: ,'$ADDRESS_ID$'

Line 3606: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ZX_LINES_DET_FACTORS zxdf ' );

3602: -- FH: Added ZX table for modelo project
3603: lc_jgzz_modelo_query :=
3604: REPLACE( lc_jgzz_modelo_query
3605: , '$MODELO_TABLE_LIST$'
3606: ,' , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca, ZX_LINES_DET_FACTORS zxdf ' );
3607:
3608: G_LINENO := '2.3.3';
3609: lc_jgzz_modelo_query :=
3610: REPLACE( lc_jgzz_modelo_query

Line 4881: , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca

4877: hzcsu.cust_acct_site_id
4878: $YEAR_AMT_RECEIVED_CASH$
4879: $TRANSMISSION_PROPERTY$
4880: FROM jg_zz_vat_trx_details jzvtd, jg_zz_vat_rep_status jzvrs
4881: , hz_cust_site_uses_all hzcsu ,hz_cust_acct_sites_all hzcas ,hz_cust_accounts hzca
4882: , ZX_LINES_DET_FACTORS zxdf, ra_customer_trx_all trx
4883: WHERE (substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3) in (''347'',''349'',''415'')
4884: OR substr(zxdf.document_sub_type,1,6) = ''MOD340'')
4885: AND nvl(zxdf.document_sub_type,''X'') <> ''MOD340_EXCL''