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.WMS_LMS_UTILS dependencies on WMS_ELS_EXP_RESOURCE

Line 1056: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_exp_resource

1052: RETURN NUMBER IS
1053: is_unprocessed NUMBER;
1054: BEGIN
1055:
1056: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_exp_resource
1057: where els_data_id IS NULL and organization_id = p_org_id
1058: );
1059: RETURN 1;
1060:

Line 1348: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1

1344: FUNCTION getWorkOutstanding(l_ActivityId IN NUMBER, l_ActivityDetailId IN NUMBER, l_OrgId IN NUMBER)
1345: RETURN VARCHAR2 IS
1346: CURSOR CUR_WRK_OUTSTANDING(p_ActivityId number, p_activityDetailId number, p_OrgId number) IS
1347: SELECT COUNT(*) || ' ' || NVL(DOCUMENT_TYPE, ML1.MEANING) AS WORK
1348: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1
1349: WHERE ORGANIZATION_ID = p_OrgId
1350: AND ACTIVITY_ID = p_ActivityId
1351: AND ACTIVITY_DETAIL_ID = p_ActivityDetailId
1352: AND ML1.LOOKUP_TYPE = 'WMS_ELS_TASKS_LOOKUP'

Line 1377: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1

1373: RETURN NUMBER
1374: IS
1375: CURSOR CUR_WRK_OUTSTANDING(p_ActivityId number, p_activityDetailId number, p_OrgId number) IS
1376: SELECT COUNT(*) AS WORK
1377: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1
1378: WHERE ORGANIZATION_ID = p_OrgId
1379: AND ACTIVITY_ID = p_ActivityId
1380: AND ACTIVITY_DETAIL_ID = p_ActivityDetailId
1381: AND ML1.LOOKUP_TYPE = 'WMS_ELS_TASKS_LOOKUP';