DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUST_TRX_TYPES

Line 148: ,ra_cust_trx_types RCTT

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

Line 168: ,ra_cust_trx_types_all RCTT

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