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.XNP_WF_STANDARD dependencies on XNP_SV_SMS

Line 3123: FROM XNP_SV_SMS_FE_MAPS

3119: l_ENDING_NUMBER VARCHAR2(80) := NULL;
3120:
3121: CURSOR c_ALL_FEs IS
3122: SELECT FE_ID
3123: FROM XNP_SV_SMS_FE_MAPS
3124: WHERE SV_SMS_ID IN
3125: (SELECT SV_SMS_ID FROM XNP_SV_SMS
3126: WHERE SUBSCRIPTION_TN
3127: BETWEEN l_STARTING_NUMBER AND l_ENDING_NUMBER

Line 3125: (SELECT SV_SMS_ID FROM XNP_SV_SMS

3121: CURSOR c_ALL_FEs IS
3122: SELECT FE_ID
3123: FROM XNP_SV_SMS_FE_MAPS
3124: WHERE SV_SMS_ID IN
3125: (SELECT SV_SMS_ID FROM XNP_SV_SMS
3126: WHERE SUBSCRIPTION_TN
3127: BETWEEN l_STARTING_NUMBER AND l_ENDING_NUMBER
3128: )
3129: AND FEATURE_TYPE=l_FEATURE_TYPE

Line 4522: FROM XNP_SV_SMS_FE_MAPS

4518: l_ENDING_NUMBER VARCHAR2(80) := NULL;
4519:
4520: CURSOR c_ALL_FEs IS
4521: SELECT FE_ID
4522: FROM XNP_SV_SMS_FE_MAPS
4523: WHERE SV_SMS_ID IN
4524: (SELECT SV_SMS_ID FROM XNP_SV_SMS
4525: WHERE SUBSCRIPTION_TN
4526: BETWEEN l_STARTING_NUMBER AND l_ENDING_NUMBER

Line 4524: (SELECT SV_SMS_ID FROM XNP_SV_SMS

4520: CURSOR c_ALL_FEs IS
4521: SELECT FE_ID
4522: FROM XNP_SV_SMS_FE_MAPS
4523: WHERE SV_SMS_ID IN
4524: (SELECT SV_SMS_ID FROM XNP_SV_SMS
4525: WHERE SUBSCRIPTION_TN
4526: BETWEEN l_STARTING_NUMBER AND l_ENDING_NUMBER
4527: )
4528: AND FEATURE_TYPE=l_FEATURE_TYPE