APPS.ARP_RECEIPTS_MAIN dependencies on RA_CUSTOMER_TRX_LINES

Line 698: FROM ra_customer_trx_lines ctl,

694: --{ For CM APP on legacy from 11i
695: (SELECT tt.type type,
696: ctl.customer_trx_line_id customer_trx_line_id,
697: ctl.line_type line_type
698: FROM ra_customer_trx_lines ctl,
699: ra_customer_trx trx,
700: ra_cust_trx_types tt
701: WHERE ctl.customer_trx_id = trx.customer_trx_id
702: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 770: FROM ra_customer_trx_lines ctl,

766: -- For CM APP on legacy from 11i
767: (SELECT tt.type type,
768: ctl.customer_trx_line_id customer_trx_line_id,
769: ctl.line_type line_type
770: FROM ra_customer_trx_lines ctl,
771: ra_customer_trx trx,
772: ra_cust_trx_types tt
773: WHERE ctl.customer_trx_id = trx.customer_trx_id
774: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 1149: UPDATE ra_customer_trx_lines

1145: --{3377004
1146: IF l_index <> 0 THEN
1147:
1148: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1149: UPDATE ra_customer_trx_lines
1150: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1151: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1152: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1153: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1158: UPDATE ra_customer_trx_lines_gt

1154: WHERE customer_trx_line_id = l_ctl_rem_amt.customer_trx_line_id(m);
1155:
1156: --BUG#4753570 make the amount on trx line and gloabl has to in sync
1157: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1158: UPDATE ra_customer_trx_lines_gt
1159: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1160: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1161: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1162: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)