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.

[Home] [Help]

APPS.PO_HEADERS_PKG_S2 dependencies on DUAL

Line 331: from sys.dual

327: X_progress := '010';
328:
329: SELECT 'no duplicates'
330: into X_dummy
331: from sys.dual
332: where not exists
333: (SELECT 'po number is not unique'
334: FROM po_headers ph
335: WHERE ph.segment1 = X_segment1

Line 344: from sys.dual

340: X_Progress := '020';
341:
342: SELECT 'no duplicates'
343: into X_dummy
344: from sys.dual
345: where not exists
346: (SELECT 'po number is not unique'
347: FROM po_history_pos ph
348: WHERE ph.segment1 = X_segment1

Line 387: from sys.dual

383: X_progress := '050';
384:
385: SELECT 'no duplicates'
386: into X_dummy
387: from sys.dual
388: where not exists
389: (SELECT 'rfq/quote number is not unique'
390: FROM po_headers ph
391: WHERE ph.segment1 = X_segment1

Line 399: from sys.dual

395: X_Progress := '060';
396:
397: SELECT 'no duplicates'
398: into X_dummy
399: from sys.dual
400: where not exists
401: (SELECT 'rfq/quote number is not unique'
402: FROM po_history_pos ph
403: WHERE ph.segment1 = X_segment1