DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_AR_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 67: ,ra_customer_trx_all RCTA

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

Line 104: ,ra_customer_trx_all RCTA

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

Line 142: ,ra_customer_trx_all RCTA

138: FROM jg_zz_vat_trx_details JZVTD
139: ,jg_zz_vat_rep_status JZVRS
140: ,hz_locations HZ
141: ,hz_party_sites HPS
142: ,ra_customer_trx_all RCTA
143: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
144: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
145: AND JZVRS.source = 'AR'
146: AND JZVRS.tax_calendar_period = p_period