DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 994: hz_cust_acct_sites_all hzcas,

990: ra_cust_trx_line_gl_dist_all rcgl,
991: ra_customer_trx_lines_all rtlitem,
992: ra_cust_trx_line_gl_dist_all rcglitem,
993: hz_cust_site_uses_all hzcsu,
994: hz_cust_acct_sites_all hzcas,
995: hz_cust_accounts hzca,
996: hz_parties hzp,
997: jg_zz_vat_rep_entities repent,
998: zx_rates_b zxrates,

Line 1637: hz_cust_acct_sites_all hzcas,

1633: hzp.jgzz_fiscal_code tax_payer_id, -- Customer Tax Payer ID
1634: DECODE(hzcsu.tax_reference, null,hzp.tax_reference,hzcsu.tax_reference) vat_reg_num-- Customer Tax Registration Number
1635: FROM JE_IT_LIST_LINES_ALL jit,
1636: hz_cust_site_uses_all hzcsu,
1637: hz_cust_acct_sites_all hzcas,
1638: hz_cust_accounts hzca,
1639: hz_parties hzp
1640: WHERE jit.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
1641: AND jit.year_of_declaration = P_YEAR_OF_DECLARATION

Line 1731: hz_cust_acct_sites_all hzcas,

1727: hzp.jgzz_fiscal_code tax_payer_id, -- Customer Tax Payer ID
1728: DECODE(hzcsu.tax_reference, null,hzp.tax_reference,hzcsu.tax_reference) vat_reg_num-- Customer Tax Registration Number
1729: FROM JE_IT_LIST_LINES_ALL jit,
1730: hz_cust_site_uses_all hzcsu,
1731: hz_cust_acct_sites_all hzcas,
1732: hz_cust_accounts hzca,
1733: hz_parties hzp
1734: WHERE jit.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
1735: AND jit.year_of_declaration = P_YEAR_OF_DECLARATION