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_RESALE_PUB dependencies on OZF_RESALE_BATCHES_ALL

Line 49: FROM ozf_resale_batches_all

45: l_msg_count NUMBER;
46:
47: CURSOR csr_batch_org_id(cv_resale_batch_id IN NUMBER) IS
48: SELECT org_id
49: FROM ozf_resale_batches_all
50: WHERE resale_batch_id = cv_resale_batch_id;
51:
52: l_resale_org_id NUMBER;
53:

Line 184: FROM ozf_resale_batches_all

180: l_msg_count NUMBER;
181:
182: CURSOR csr_batch_org_id(cv_resale_batch_id IN NUMBER) IS
183: SELECT org_id
184: FROM ozf_resale_batches_all
185: WHERE resale_batch_id = cv_resale_batch_id;
186:
187: l_resale_org_id NUMBER;
188:

Line 521: FROM ozf_resale_batches_all

517: CURSOR c_resale_batch_id (cv_resale_batch_id IN NUMBER)IS
518: SELECT resale_batch_id
519: ,currency_code
520: ,org_id
521: FROM ozf_resale_batches_all
522: WHERE resale_batch_id = cv_resale_batch_id
523: AND status_code = 'CLOSED';
524:
525: CURSOR c_get_resale_lines (cv_resale_batch_id IN NUMBER

Line 548: ozf_resale_batches_all orb,

544: ,orl.last_updated_by
545: ,orl.org_id
546: ,orl.supplier_item_cost
547: FROM ozf_resale_lines_all orl,
548: ozf_resale_batches_all orb,
549: ozf_resale_batch_line_maps_all orblm
550: WHERE orblm.resale_batch_id = orb.resale_batch_id
551: AND orblm.resale_line_id = orl.resale_line_id
552: AND orb.resale_batch_id = cv_resale_batch_id