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.OZF_SETTLEMENT_DOC_PVT dependencies on AR_RECEIVABLES_TRX

Line 89: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS

85: SELECT trx_number
86: FROM ar_payment_schedules
87: WHERE payment_schedule_id = cv_settlement_type_id;
88:
89: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
90: SELECT name
91: FROM ar_receivables_trx
92: WHERE receivables_trx_id = cv_settlement_type_id;
93:

Line 91: FROM ar_receivables_trx

87: WHERE payment_schedule_id = cv_settlement_type_id;
88:
89: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
90: SELECT name
91: FROM ar_receivables_trx
92: WHERE receivables_trx_id = cv_settlement_type_id;
93:
94: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
95: SELECT meaning

Line 155: OPEN csr_ar_receivables_trx (p_settlement_type_id);

151: OPEN csr_ar_payment_schedules (p_settlement_type_id);
152: FETCH csr_ar_payment_schedules INTO x_settlement_type;
153: CLOSE csr_ar_payment_schedules;
154: ELSE
155: OPEN csr_ar_receivables_trx (p_settlement_type_id);
156: FETCH csr_ar_receivables_trx INTO x_settlement_type;
157: CLOSE csr_ar_receivables_trx;
158: END IF;
159: ELSE

Line 156: FETCH csr_ar_receivables_trx INTO x_settlement_type;

152: FETCH csr_ar_payment_schedules INTO x_settlement_type;
153: CLOSE csr_ar_payment_schedules;
154: ELSE
155: OPEN csr_ar_receivables_trx (p_settlement_type_id);
156: FETCH csr_ar_receivables_trx INTO x_settlement_type;
157: CLOSE csr_ar_receivables_trx;
158: END IF;
159: ELSE
160: OPEN csr_ozf_lookups_trx (p_payment_method);

Line 157: CLOSE csr_ar_receivables_trx;

153: CLOSE csr_ar_payment_schedules;
154: ELSE
155: OPEN csr_ar_receivables_trx (p_settlement_type_id);
156: FETCH csr_ar_receivables_trx INTO x_settlement_type;
157: CLOSE csr_ar_receivables_trx;
158: END IF;
159: ELSE
160: OPEN csr_ozf_lookups_trx (p_payment_method);
161: FETCH csr_ozf_lookups_trx INTO x_settlement_type;

Line 433: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS

429: SELECT trx_number
430: FROM ar_payment_schedules
431: WHERE payment_schedule_id = cv_settlement_type_id;
432:
433: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
434: SELECT name
435: FROM ar_receivables_trx
436: WHERE receivables_trx_id = cv_settlement_type_id;
437:

Line 435: FROM ar_receivables_trx

431: WHERE payment_schedule_id = cv_settlement_type_id;
432:
433: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
434: SELECT name
435: FROM ar_receivables_trx
436: WHERE receivables_trx_id = cv_settlement_type_id;
437:
438: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
439: SELECT meaning

Line 1669: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS

1665: SELECT trx_number
1666: FROM ar_payment_schedules
1667: WHERE payment_schedule_id = cv_settlement_type_id;
1668:
1669: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
1670: SELECT name
1671: FROM ar_receivables_trx
1672: WHERE receivables_trx_id = cv_settlement_type_id;
1673:

Line 1671: FROM ar_receivables_trx

1667: WHERE payment_schedule_id = cv_settlement_type_id;
1668:
1669: CURSOR csr_ar_receivables_trx(cv_settlement_type_id IN NUMBER) IS
1670: SELECT name
1671: FROM ar_receivables_trx
1672: WHERE receivables_trx_id = cv_settlement_type_id;
1673:
1674: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
1675: SELECT meaning