APPS.AR_LL_RCV_SUMMARY_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 16: from ra_customer_trx_lines

12: WHERE 1 = 1
13: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
14: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
15: AND CUSTOMER_TRX_LINE_ID in (select customer_trx_line_id
16: from ra_customer_trx_lines
17: where customer_trx_id = X_CUSTOMER_TRX_ID);
18: IF ( SQL%NOTFOUND ) THEN
19: -- 17 Jan 2006, don't need to raise error, when there are no rows
20: /*RAISE NO_DATA_FOUND;

Line 177: from ra_customer_trx_lines line,

173: line.amount_due_original line_orig,
174: tax.amount_due_remaining tax_rem,
175: tax.amount_due_original tax_orig,
176: line.source_data_key4 group_id
177: from ra_customer_trx_lines line,
178: (select link_to_cust_trx_line_id,
179: line_type,
180: sum(nvl(amount_due_original,0)) amount_due_original,
181: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 182: from ra_customer_trx_lines

178: (select link_to_cust_trx_line_id,
179: line_type,
180: sum(nvl(amount_due_original,0)) amount_due_original,
181: sum(nvl(amount_due_remaining,0)) amount_due_remaining
182: from ra_customer_trx_lines
183: where nvl(line_type,'TAX') = 'TAX'
184: and customer_trx_id = x_customer_trx_id
185: group by link_to_cust_trx_line_id,
186: line_type

Line 240: from ra_customer_trx_lines line,

236: sum(nvl(tax.amount_due_original,0))
237: into line_count,
238: all_linrem_tot, all_taxrem_tot,
239: all_linorig_tot, all_taxorig_tot
240: from ra_customer_trx_lines line,
241: (select link_to_cust_trx_line_id,
242: line_type,
243: sum(nvl(amount_due_original,0)) amount_due_original,
244: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 245: from ra_customer_trx_lines

241: (select link_to_cust_trx_line_id,
242: line_type,
243: sum(nvl(amount_due_original,0)) amount_due_original,
244: sum(nvl(amount_due_remaining,0)) amount_due_remaining
245: from ra_customer_trx_lines
246: where nvl(line_type,'TAX') = 'TAX'
247: and customer_trx_id = x_customer_trx_id
248: group by link_to_cust_trx_line_id,
249: line_type

Line 472: from ra_customer_trx_lines line

468: -- would have updated the values to not-nulls
469: line.amount_due_remaining frt_rem,
470: line.amount_due_original frt_orig,
471: NULL group_id
472: from ra_customer_trx_lines line
473: where line.line_type = 'FREIGHT'
474: and line.customer_trx_id = x_customer_trx_id;
475:
476: frt_row c_frt%rowtype;

Line 498: from ra_customer_trx_lines line

494: select count(*) row_count,
495: sum(line.amount_due_remaining) all_frtrem_tot,
496: sum(line.amount_due_original) all_frtorig_tot
497: into line_count, all_frtrem_tot, all_frtorig_tot
498: from ra_customer_trx_lines line
499: where line.customer_trx_id = x_customer_trx_id
500: and line.line_type = 'FREIGHT'
501: ;
502: exception

Line 674: from ra_customer_trx_lines line

670: -- would have updated the values to not-nulls
671: line.amount_due_remaining chg_rem,
672: line.amount_due_original chg_orig,
673: NULL group_id
674: from ra_customer_trx_lines line
675: where line.line_type = 'CHARGES'
676: and line.customer_trx_id = x_customer_trx_id;
677:
678: chg_row c_chg%rowtype;

Line 697: from ra_customer_trx_lines line

693: sum(nvl(line.amount_due_remaining,0)),
694: sum(nvl(line.amount_due_remaining,0))
695: into line_count, all_chgrem_tot,
696: all_chgorig_tot
697: from ra_customer_trx_lines line
698: where line.customer_trx_id = x_customer_trx_id
699: and line.line_type = 'CHARGES'
700: ;
701: exception

Line 930: ra_customer_trx_lines rctl

926: LLD.SOURCE_TABLE,
927: ar_activity_details_s.nextval,
928: 'R'
929: FROM ar_Activity_details LLD,
930: ra_customer_trx_lines rctl
931: WHERE rctl.CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID
932: AND LLD.CUSTOMER_TRX_LINE_ID = rctl.CUSTOMER_TRX_LINE_ID
933: AND LLD.CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
934: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';

Line 943: from ra_customer_trx_lines

939: WHERE CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
940: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
941: AND CUSTOMER_TRX_LINE_ID IN
942: ( select CUSTOMER_TRX_LINE_ID
943: from ra_customer_trx_lines
944: where CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID
945: );
946:
947: