APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUSTOMER_TRX

Line 122: AND FDFCU.descriptive_flexfield_name = 'RA_CUSTOMER_TRX'

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

Line 146: ,ra_customer_trx_lines RCTL

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

Line 147: ,ra_customer_trx RCT

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

Line 166: FROM ra_customer_trx RCT

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

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

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

Line 205: ,ra_customer_trx_all RCT

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