DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_AR_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 69: ,ra_customer_trx_all RCTA

65: ,jg_zz_vat_rep_status JZVRS
66: ,hz_cust_acct_sites_all HZCAS
67: ,hz_party_sites HPS
68: ,hz_locations HZL
69: ,ra_customer_trx_all RCTA
70: ,ra_cust_trx_types RTT
71: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
72: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
73: AND JZVRS.source = 'AR'

Line 106: ,ra_customer_trx_all RCTA

102: ,JZVTD.accounting_date GL_DATE
103: ,NVL(JZVTD.taxable_amt_funcl_curr,taxable_amt) TAXABLE_AMOUNT
104: FROM jg_zz_vat_trx_details JZVTD
105: ,jg_zz_vat_rep_status JZVRS
106: ,ra_customer_trx_all RCTA
107: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
108: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
109: AND JZVRS.tax_calendar_period = p_period
110: AND JZVTD.trx_id = RCTA.customer_trx_id

Line 147: ,ra_customer_trx_all RCTA

143: FROM jg_zz_vat_trx_details JZVTD
144: ,jg_zz_vat_rep_status JZVRS
145: ,hz_locations HZ
146: ,hz_party_sites HPS
147: ,ra_customer_trx_all RCTA
148: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
149: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
150: AND JZVRS.source = 'AR'
151: AND JZVRS.tax_calendar_period = p_period