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.QLTCPPLB dependencies on ALR_ACTION_SET_MEMBERS

Line 131: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,

127: CURSOR CS3 IS
128: SELECT
129: ALR_ACTIONS_S.NEXTVAL,
130: ALR_ACTION_SETS_S.NEXTVAL,
131: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
132: QA_ALR_ACTION_NAME_S.NEXTVAL,
133: QA_ALR_ACTION_SET_NAME_S.NEXTVAL
134: FROM DUAL;
135:

Line 632: FROM ALR_ACTION_SET_MEMBERS

628:
629: BEGIN
630: SELECT NVL(MAX(SEQUENCE),0)+1
631: INTO ACTION_SET_MEMBERS_SEQUENCE
632: FROM ALR_ACTION_SET_MEMBERS
633: WHERE APPLICATION_ID = 250
634: AND ALERT_ID = 10177
635: AND ACTION_SET_ID = NEW_ACTION_SET_ID;
636: EXCEPTION

Line 641: INSERT INTO ALR_ACTION_SET_MEMBERS (

637: WHEN NO_DATA_FOUND THEN
638: ACTION_SET_MEMBERS_SEQUENCE := 1;
639: END;
640:
641: INSERT INTO ALR_ACTION_SET_MEMBERS (
642: APPLICATION_ID,
643: ACTION_SET_MEMBER_ID,
644: ACTION_SET_ID,
645: ACTION_ID,