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_TP_ACCRUAL_PVT dependencies on DUAL

Line 193: FROM dual

189: FND_MESSAGE.get_string('OZF','OZF_BATCH_STATUS_WNG'),
190: 'STATUS_CODE',
191: l_status_code,
192: l_org_id
193: FROM dual
194: WHERE NOT EXISTS (
195: SELECT 1
196: FROM ozf_resale_logs a
197: WHERE a.resale_id = p_resale_batch_id

Line 2595: FROM dual; */

2591: l_org_id NUMBER;
2592: -- Start: bug # 5997978 fixed
2593: /*CURSOR org_id_csr IS
2594: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
2595: FROM dual; */
2596: l_batch_org_id NUMBER;
2597: CURSOR org_id_csr(cv_resale_batch_id IN NUMBER) IS
2598: SELECT org_id
2599: FROM ozf_resale_batches_all

Line 3861: FROM dual;

3857: l_obj_number NUMBER := 1.0;
3858:
3859: CURSOR resale_batch_id_csr IS
3860: SELECT ozf_resale_batches_all_s.nextval
3861: FROM dual;
3862: l_resale_batch_id NUMBER;
3863:
3864: CURSOR resale_batch_number_csr IS
3865: SELECT to_char(ozf_resale_batch_number_s.nextval)

Line 3866: FROM dual;

3862: l_resale_batch_id NUMBER;
3863:
3864: CURSOR resale_batch_number_csr IS
3865: SELECT to_char(ozf_resale_batch_number_s.nextval)
3866: FROM dual;
3867: l_resale_batch_number VARCHAR2(30);
3868:
3869: CURSOR line_info_csr(p_id NUMBER,
3870: p_org_id NUMBER,