DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUST_TRX_TYPES

Line 149: ,ra_cust_trx_types RCTT

145: INTO ln_commitment_bal
146: FROM hz_cust_accounts HCA
147: ,ra_customer_trx_lines RCTL
148: ,ra_customer_trx RCT
149: ,ra_cust_trx_types RCTT
150: WHERE RCT.customer_trx_id = p_customer_trx_id
151: AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id
152: AND RCT.org_id = RCTT.org_id
153: AND RCT.customer_trx_id = RCTL.customer_trx_id

Line 169: ,ra_cust_trx_types_all RCTT

165: SELECT NVL( ln_commitment_bal, 0) - (NVL(SUM( ARA.AMOUNT),0) * -1)
166: INTO ln_invoice_bal
167: FROM ra_customer_trx RCT
168: ,ra_cust_trx_line_gl_dist_all RCTD
169: ,ra_cust_trx_types_all RCTT
170: ,hz_cust_accounts HCA
171: ,hz_parties HZP
172: ,gl_code_combinations GCC
173: ,ar_adjustments_all ARA