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.AS_STATUS_PUB dependencies on AS_STATUSES_VL

Line 72: FROM as_statuses_vl

68:
69: -- Cursor for checking duplicate status code
70: CURSOR status_dup_cur(p_status_code IN VARCHAR2) IS
71: SELECT 1
72: FROM as_statuses_vl
73: WHERE TRIM(NLS_UPPER(status_code)) = p_status_code; -- trimmed value passed while opening
74:
75: BEGIN
76: -- Standard start of api save point

Line 564: FROM as_statuses_vl

560: attribute15,
561: meaning,
562: description,
563: status_rank
564: FROM as_statuses_vl
565: WHERE TRIM(NLS_UPPER(status_code)) = p_status_code; -- trimmed value passed while opening
566:
567: CURSOR lock_row_for_update(p_status_code in VARCHAR2) IS
568: SELECT last_update_date

Line 569: FROM as_statuses_vl

565: WHERE TRIM(NLS_UPPER(status_code)) = p_status_code; -- trimmed value passed while opening
566:
567: CURSOR lock_row_for_update(p_status_code in VARCHAR2) IS
568: SELECT last_update_date
569: FROM as_statuses_vl
570: WHERE TRIM(NLS_UPPER(status_code)) = p_status_code; -- trimmed value passed while opening
571:
572:
573: