DBA Data[Home] [Help]

APPS.JG_ZZ_RTCE_DT_PKG dependencies on RA_CUSTOMER_TRX

Line 85: FROM ra_customer_trx ract

81: ,ractl.extended_amount
82: ,ractl.vat_tax_id
83: ,sum(racgd.acctd_amount) acctd_amount
84: ,sum(racgd.amount) amount
85: FROM ra_customer_trx ract
86: ,ra_customer_trx_lines ractl
87: ,ra_cust_trx_line_gl_dist racgd
88: ,jg_zz_vat_rep_entities repent
89: WHERE repent.vat_reporting_entity_id = P_REPORTING_ENTITY_ID

Line 86: ,ra_customer_trx_lines ractl

82: ,ractl.vat_tax_id
83: ,sum(racgd.acctd_amount) acctd_amount
84: ,sum(racgd.amount) amount
85: FROM ra_customer_trx ract
86: ,ra_customer_trx_lines ractl
87: ,ra_cust_trx_line_gl_dist racgd
88: ,jg_zz_vat_rep_entities repent
89: WHERE repent.vat_reporting_entity_id = P_REPORTING_ENTITY_ID
90: AND (( repent.entity_type_code = 'LEGAL' AND