APPS.JE_IT_LISTING_PKG dependencies on HZ_CUST_ACCOUNTS

Line 995: hz_cust_accounts hzca,

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,
999: zx_taxes_b zxtaxes,

Line 1638: hz_cust_accounts hzca,

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
1642: AND jit.APPLICATION_ID = 222

Line 1732: hz_cust_accounts hzca,

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
1736: AND jit.APPLICATION_ID = 222

Line 1748: hz_cust_accounts hzca,

1744: AND hzp.country = gv_vat_country_code
1745: AND NVL(decode(hzcsu.tax_reference, null,hzp.tax_reference,hzcsu.tax_reference),'-99') <> TO_CHAR(gv_repent_trn)
1746: GROUP BY jit.APPLICATION_ID, hzp.jgzz_fiscal_code, DECODE(hzcsu.tax_reference, null,hzp.tax_reference,hzcsu.tax_reference)
1747: ) COLLECTION,
1748: hz_cust_accounts hzca,
1749: hz_parties hzp
1750: WHERE
1751: COLLECTION.party_id = hzca.cust_account_id
1752: AND hzca.party_id = hzp.party_id