APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 290: , hz_cust_acct_sites_all hzcas

286: ,decode(to_char(jzvtd.gl_date,'MM'),'01','1T','02','1T','03','1T','04','2T','05','2T','06','2T','07','3T','08','3T','09','3T','10','4T','11','4T','12','4T') QUARTER_NUM
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:

Line 436: FROM hz_cust_acct_sites_all HCAS

432: , SUBSTR(HL.ADDRESS1,1,2) ||
433: SUBSTR(HL.ADDRESS2,1,23) ||
434: LPAD(SUBSTR(HL.ADDRESS3,1,length(HL.ADDRESS3) -
435: NVL(LENGTH(LTRIM(TRANSLATE(HL.ADDRESS3, '123456789','000000000'),'0')),0)),5,'0') address_detail
436: FROM hz_cust_acct_sites_all HCAS
437: , hz_party_sites HPS
438: , hz_locations HL --12656346
439: , fnd_territories FT
440: , hz_cust_site_uses_all HCSU

Line 481: FROM hz_cust_acct_sites_all HCAS

477: , SUBSTR(HL.address2,1,25) via_publica
478: , SUBSTR(HL.address3||'Z',1,INSTR(HL.address3||'Z',
479: LTRIM(HL.address3||'Z','1234567890')) - 1) numero
480: , HL.country
481: FROM hz_cust_acct_sites_all HCAS
482: , hz_party_sites HPS
483: , hz_locations HL
484: , fnd_territories FT
485: , hz_cust_site_uses_all HCSU

Line 645: , hz_cust_acct_sites_all HCAS

641: -- 4 Property located outside Spain
642: 4) property_location_code
643: FROM jg_zz_vat_rep_status JZVRS
644: , jg_zz_vat_trx_details JZVTD
645: , hz_cust_acct_sites_all HCAS
646: , hz_party_sites HPS
647: , hr_locations HL
648: -- , fnd_territories FT -- Bug 8485057: not necessary
649: , hz_cust_site_uses_all HCSU

Line 1217: , hz_cust_acct_sites_all HCAS

1213: , g_cur_precision)
1214: )
1215: INTO v_arrenda_amount
1216: FROM JG_ZZ_VAT_TRX_GT JVGT
1217: , hz_cust_acct_sites_all HCAS
1218: , hz_party_sites HPS
1219: , hz_locations HL
1220: , fnd_territories FT
1221: , hz_cust_site_uses_all HCSU

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''