APPS.ARP_RECEIPTS_MAIN dependencies on RA_CUSTOMER_TRX_LINES

Line 683: FROM ra_customer_trx_lines ctl,

679: --{ For CM APP on legacy from 11i
680: (SELECT tt.type type,
681: ctl.customer_trx_line_id customer_trx_line_id,
682: ctl.line_type line_type
683: FROM ra_customer_trx_lines ctl,
684: ra_customer_trx trx,
685: ra_cust_trx_types tt
686: WHERE ctl.customer_trx_id = trx.customer_trx_id
687: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 751: FROM ra_customer_trx_lines ctl,

747: -- For CM APP on legacy from 11i
748: (SELECT tt.type type,
749: ctl.customer_trx_line_id customer_trx_line_id,
750: ctl.line_type line_type
751: FROM ra_customer_trx_lines ctl,
752: ra_customer_trx trx,
753: ra_cust_trx_types tt
754: WHERE ctl.customer_trx_id = trx.customer_trx_id
755: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 1106: UPDATE ra_customer_trx_lines

1102: --{3377004
1103: IF l_index <> 0 THEN
1104:
1105: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1106: UPDATE ra_customer_trx_lines
1107: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1108: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1109: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1110: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1115: UPDATE ra_customer_trx_lines_gt

1111: WHERE customer_trx_line_id = l_ctl_rem_amt.customer_trx_line_id(m);
1112:
1113: --BUG#4753570 make the amount on trx line and gloabl has to in sync
1114: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1115: UPDATE ra_customer_trx_lines_gt
1116: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1117: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1118: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1119: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)