APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUSTOMER_TRX

Line 123: AND FDFCU.descriptive_flexfield_name = 'RA_CUSTOMER_TRX'

119: FROM fnd_descr_flex_col_usage_vl FDFCU
120: ,fnd_flex_values_vl FFV
121: WHERE FDFCU.flex_value_set_id = FFV.flex_value_set_id
122: AND FDFCU.application_id = 222
123: AND FDFCU.descriptive_flexfield_name = 'RA_CUSTOMER_TRX'
124: AND FDFCU.descriptive_flex_context_code ='Global Data Elements'
125: AND FDFCU.application_column_name = p_segment
126: AND FFV.flex_value = p_value;
127: END IF;

Line 147: ,ra_customer_trx_lines RCTL

143: BEGIN /*Query to find the Balances for the given Customer Trx Id */
144: SELECT NVL(RCTL.extended_amount,0)
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

Line 148: ,ra_customer_trx RCT

144: SELECT NVL(RCTL.extended_amount,0)
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

Line 167: FROM ra_customer_trx RCT

163:
164: BEGIN
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

Line 177: AND RCT.customer_trx_id = DECODE(RCTT.type, 'INV', ARA.customer_trx_id,

173: ,ar_adjustments_all ARA
174: ,ar_distributions_all ARD
175: WHERE RCT.initial_customer_trx_id = p_customer_trx_id
176: AND RCTD.customer_trx_id = RCT.customer_trx_id
177: AND RCT.customer_trx_id = DECODE(RCTT.type, 'INV', ARA.customer_trx_id,
178: 'CM', ARA.subsequent_trx_id)
179: AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id
180: AND RCT.org_id = RCTT.org_id
181: AND RCT.bill_to_customer_id = HCA.cust_account_id

Line 206: ,ra_customer_trx_all RCT

202: BEGIN
203: SELECT NVL(SUM(APSA.amount_due_original),0)
204: INTO ln_deposit_cancel
205: FROM ar_payment_schedules_all APSA
206: ,ra_customer_trx_all RCT
207: WHERE RCT.previous_customer_trx_id=p_customer_trx_id
208: AND APSA.gl_date < gc_per_start_date
209: AND RCT.customer_trx_id=APSA.customer_trx_id
210: AND APSA.class = 'CM';