eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_PAYMENT_SCHEDULES

Line 110: FROM ar_payment_schedules ps

106: ELSE
107:
108: SELECT SUM( NVL( ps.AMOUNT_IN_DISPUTE, 0) )
109: INTO l_amount_in_dispute
110: FROM ar_payment_schedules ps
111: WHERE ps.customer_trx_id = p_customer_trx_id;
112:
113: RETURN(l_amount_in_dispute);
114:

Line 156: l_dispute_date ar_payment_schedules.dispute_date%type;

152: p_class IN varchar2,
153: p_open_receivable_flag IN varchar2)
154: RETURN DATE IS
155:
156: l_dispute_date ar_payment_schedules.dispute_date%type;
157:
158: BEGIN
159:
160: /*------------------------------------------------------------+

Line 171: FROM ar_payment_schedules ps

167: ELSE
168:
169: SELECT MAX(ps.dispute_date )
170: INTO l_dispute_date
171: FROM ar_payment_schedules ps
172: WHERE ps.customer_trx_id = p_customer_trx_id
173: AND ps.dispute_date IS NOT NULL;
174:
175: RETURN(l_dispute_date);

Line 218: l_dispute_date ar_payment_schedules.dispute_date%type;

214: p_class IN varchar2,
215: p_open_receivable_flag IN varchar2)
216: RETURN DATE IS
217:
218: l_dispute_date ar_payment_schedules.dispute_date%type;
219:
220: BEGIN
221:
222: /*------------------------------------------------------------+

Line 234: ar_payment_schedules ps

230:
231: SELECT MAX(h.start_date)
232: INTO l_dispute_date
233: FROM ar_dispute_history h,
234: ar_payment_schedules ps
235: WHERE h.payment_schedule_id = ps.payment_schedule_id
236: AND ps.customer_trx_id = p_customer_trx_id
237: AND end_date IS NULL;
238:

Line 530: FROM ar_payment_schedules

526: +-------------------------------------------*/
527:
528: SELECT COUNT(*)
529: INTO l_auto_rec_count
530: FROM ar_payment_schedules
531: WHERE customer_trx_id = p_customer_trx_id
532: AND selected_for_receipt_batch_id IS NOT NULL;
533:
534: /*-----------------------------------------------+

Line 550: FROM ar_payment_schedules ps,

546: +-------------------------------------------------------*/
547:
548: SELECT COUNT(DISTINCT ps.payment_schedule_id)
549: INTO l_auto_rec_approved_count
550: FROM ar_payment_schedules ps,
551: ar_receivable_applications ra,
552: ar_cash_receipt_history crh
553: WHERE ps.customer_trx_id = p_customer_trx_id
554: AND ra.applied_payment_schedule_id = ps.payment_schedule_id

Line 747: FROM ar_payment_schedules ps

743: SELECT DECODE( MAX(ps.payment_schedule_id),
744: NULL, 'N',
745: 'Y')
746: INTO l_activity_flag
747: FROM ar_payment_schedules ps
748: WHERE ps.customer_trx_id = p_customer_trx_id
749: AND (
750: ps.amount_due_original <> ps.amount_due_remaining
751: OR NVL(ps.amount_applied,0) <> 0

Line 803: FROM ar_payment_schedules ps

799: SELECT DECODE( MAX( payment_schedule_id ),
800: NULL, 'N',
801: 'Y' )
802: INTO l_activity_flag
803: FROM ar_payment_schedules ps
804: WHERE (
805: (
806: NVL(ps.amount_credited, 0) <> 0
807: OR NVL(ps.amount_adjusted, 0) <> 0

Line 831: FROM ar_payment_schedules this_ps,

827: SELECT DECODE( MAX( other_ps.payment_schedule_id),
828: NULL, 'N',
829: 'Y')
830: INTO l_activity_flag
831: FROM ar_payment_schedules this_ps,
832: ar_payment_schedules other_ps,
833: ra_customer_trx other_ct
834: WHERE this_ps.customer_trx_id = p_customer_trx_id
835: AND other_ct.previous_customer_trx_id =

Line 832: ar_payment_schedules other_ps,

828: NULL, 'N',
829: 'Y')
830: INTO l_activity_flag
831: FROM ar_payment_schedules this_ps,
832: ar_payment_schedules other_ps,
833: ra_customer_trx other_ct
834: WHERE this_ps.customer_trx_id = p_customer_trx_id
835: AND other_ct.previous_customer_trx_id =
836: p_previous_customer_trx_id

Line 901: FROM ar_payment_schedules

897: SELECT DECODE( MAX( cons_inv_id ),
898: NULL, 'N',
899: 'Y')
900: INTO l_activity_flag
901: FROM ar_payment_schedules
902: WHERE customer_trx_id = p_customer_trx_id;
903:
904: IF (l_activity_flag = 'Y')
905: THEN RETURN('Y');

Line 1296: FROM ar_payment_schedules ps,

1292:
1293: SELECT NVL(MIN(ps.due_date),
1294: arpt_sql_func_util.get_first_due_date(p_term_id, nvl(ct.billing_date, p_trx_date)))
1295: INTO l_term_due_date
1296: FROM ar_payment_schedules ps,
1297: ra_customer_trx ct
1298: WHERE ct.customer_trx_id=ps.customer_trx_id(+)
1299: AND ct.customer_trx_id = p_customer_trx_id
1300: group by ct.billing_date;

Line 1818: | NOTES : Currently being used by -> AR_PAYMENT_SCHEDULES_V |

1814: | |
1815: | RETURNS : Batch Source Name of the Invoice associated with the |
1816: | chargeback. |
1817: | |
1818: | NOTES : Currently being used by -> AR_PAYMENT_SCHEDULES_V |
1819: | |
1820: | |
1821: | MODIFICATION HISTORY |
1822: | |

Line 1889: | NOTES : Currently being used by -> AR_PAYMENT_SCHEDULES_V |

1885: | |
1886: | RETURNS : the lastest dunning date |
1887: | |
1888: | |
1889: | NOTES : Currently being used by -> AR_PAYMENT_SCHEDULES_V |
1890: | |
1891: | |
1892: | MODIFICATION HISTORY |
1893: | |

Line 2590: FROM ar_payment_schedules

2586: AND apply_date <= p_as_of_date;
2587:
2588: SELECT amount_due_original
2589: INTO p_amt_due_original
2590: FROM ar_payment_schedules
2591: WHERE payment_schedule_id = p_applied_payment_schedule_id;
2592:
2593: /*Bug 2453245 Added p_adj_amount_applied so that
2594: Adjustment amount is also taken into account while