[Home] [Help]
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;
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
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
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
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
470: 'LINE', frt_adj_remaining, 0) frt_rem,
471: decode(line_type, 'FREIGHT', line.amount_due_original,
472: 'LINE', frt_adj_remaining, 0) frt_orig,
473: NULL group_id
474: from ra_customer_trx_lines line
475: where (line.line_type = 'FREIGHT' OR
476: (line.line_type = 'LINE'
477: and nvl(line.frt_adj_remaining,0) <> 0))
478: and line.customer_trx_id = x_customer_trx_id;
500: 'LINE', frt_adj_remaining, 0)) all_frtrem_tot,
501: sum(decode(line_type, 'FREIGHT', line.amount_due_original,
502: 'LINE', frt_adj_remaining, 0)) all_frtorig_tot
503: into line_count, all_frtrem_tot, all_frtorig_tot
504: from ra_customer_trx_lines line
505: where line.customer_trx_id = x_customer_trx_id
506: and (line.line_type = 'FREIGHT' OR
507: (line.line_type = 'LINE'
508: and nvl(line.frt_adj_remaining,0) <> 0))
680: 'LINE', line.chrg_amount_remaining, 0) chg_rem,
681: decode(line_type, 'CHARGES', line.amount_due_original,
682: 'LINE', line.chrg_amount_remaining, 0) chg_orig,
683: NULL group_id
684: from ra_customer_trx_lines line
685: where (line.line_type = 'CHARGES' OR
686: (line.line_type = 'LINE'
687: and nvl(line.chrg_amount_remaining,0) <> 0))
688: and line.customer_trx_id = x_customer_trx_id;
707: sum(nvl(decode(line_type, 'CHARGES', line.amount_due_original,
708: 'LINE', chrg_amount_remaining, 0), 0))
709: into line_count, all_chgrem_tot,
710: all_chgorig_tot
711: from ra_customer_trx_lines line
712: where line.customer_trx_id = x_customer_trx_id
713: and (line.line_type = 'CHARGES' OR
714: (line.line_type = 'LINE'
715: and nvl(line.chrg_amount_remaining,0) <> 0))
942: LLD.SOURCE_TABLE,
943: ar_activity_details_s.nextval,
944: 'R'
945: FROM ar_Activity_details LLD,
946: ra_customer_trx_lines rctl
947: WHERE rctl.CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID
948: AND LLD.CUSTOMER_TRX_LINE_ID = rctl.CUSTOMER_TRX_LINE_ID
949: AND LLD.CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
950: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
955: WHERE CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
956: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
957: AND CUSTOMER_TRX_LINE_ID IN
958: ( select CUSTOMER_TRX_LINE_ID
959: from ra_customer_trx_lines
960: where CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID
961: );
962:
963: