APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 289: , hz_cust_site_uses_all hzcsu

285:
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

Line 333: , hz_cust_site_uses_all HCSU

329: + SUM(NVL(JZVTD.tax_amt_funcl_curr, 0)) arrenda_amt_qtr
330: ,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
331: FROM jg_zz_vat_trx_details JZVTD
332: , jg_zz_vat_rep_status JZVRS
333: , hz_cust_site_uses_all HCSU
334: , zx_lines_det_factors ZXDF
335: , ra_customer_trx_all trx
336: WHERE nvl(JZVTD.billing_trading_partner_id,1) = nvl(p_customer_id,1)
337: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id

Line 440: , hz_cust_site_uses_all HCSU

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
441: WHERE HCAS.cust_acct_site_id = p_customer_address_id
442: AND HPS.party_site_id = HCAS.party_site_id
443: AND HL.location_id = HPS.location_id
444: AND HL.country(+) = FT.territory_code

Line 485: , hz_cust_site_uses_all HCSU

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
486: WHERE HCAS.cust_acct_site_id = p_customer_address_id
487: AND HPS.party_site_id = HCAS.party_site_id
488: AND HL.location_id = HPS.location_id
489: AND HL.country(+) = FT.territory_code

Line 649: , hz_cust_site_uses_all HCSU

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
650: , zx_lines_det_factors ZXDF
651: , ra_customer_trx TRX
652: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
653: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id

Line 1221: , hz_cust_site_uses_all HCSU

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
1222: WHERE JVGT.jg_info_n3 = p_customer_id
1223: AND HCAS.cust_acct_site_id = JVGT.jg_info_n2
1224: AND HPS.party_site_id = HCAS.party_site_id
1225: AND HL.location_id = HPS.location_id

Line 1251: , hz_cust_site_uses_all HCSU

1247: SUM(DECODE(JZVTD.TAX_LINE_NUMBER, '1', NVL(JZVTD.taxable_amt_funcl_curr, 0),0))
1248: + SUM(NVL(JZVTD.tax_amt_funcl_curr, 0))
1249: INTO v_arrenda_amount
1250: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1251: , hz_cust_site_uses_all HCSU
1252: , zx_lines_det_factors ZXDF -- Bug 8485057
1253: , ra_customer_trx_all trx
1254: WHERE JZVTD.billing_trading_partner_id = p_customer_id
1255: AND HCSU.cust_acct_site_id = JZVTD.billing_tp_address_id

Line 1338: , hz_cust_site_uses_all HCSU

1334: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1335: / COUNT(JZVTD.trx_id)
1336: INTO v_cash_received_amount
1337: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1338: , hz_cust_site_uses_all HCSU
1339: , zx_lines_det_factors ZXDF
1340: , ar_receivable_applications_all RA
1341: , ar_cash_receipts_all CR
1342: , ra_customer_trx_all trx

Line 1396: , hz_cust_site_uses_all HCSU

1392: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1393: / COUNT(JZVTD.trx_id)
1394: INTO v_cash_received_amount
1395: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1396: , hz_cust_site_uses_all HCSU
1397: , zx_lines_det_factors ZXDF
1398: , ar_receivable_applications_all RA
1399: , ar_cash_receipts_all CR
1400: , ra_customer_trx_all trx

Line 1475: , hz_cust_site_uses_all HCSU

1471: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1472: / COUNT(JZVTD.trx_id)
1473: INTO v_cash_received_amount
1474: FROM jg_zz_vat_trx_details JZVTD, jg_zz_vat_rep_status JZVRS
1475: , hz_cust_site_uses_all HCSU
1476: , zx_lines_det_factors ZXDF
1477: , ar_receivable_applications_all RA
1478: , ar_cash_receipts_all CR
1479: , ra_customer_trx_all trx

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