DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 993: hz_cust_site_uses_all hzcsu,

989: ra_customer_trx_lines_all rtl,
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,

Line 1636: hz_cust_site_uses_all hzcsu,

1632: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
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

Line 1730: hz_cust_site_uses_all hzcsu,

1726: SUM(jit.CM_TAXABLE_VAT_INV_AMT) tot_taxable_vat_inv_amt_cm, --TAXABLE_VAT_INV_AMT
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