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_CAROUSEL_INTEGRATION_PVT dependencies on WMS_CAROUSEL_CONFIGURATION

Line 30: FROM wms_carousel_configuration

26: p_name IN VARCHAR2
27: )
28: IS
29: SELECT CONFIG_VALUE
30: FROM wms_carousel_configuration
31: WHERE CONFIG_NAME = p_name
32: AND NVL (NVL (device_type_id, p_device_type_id), 0) = NVL (p_device_type_id, 0)
33: AND NVL (NVL (business_event_id, p_business_event_id), 0) = NVL (p_business_event_id, 0)
34: AND NVL (NVL (sequence_id, p_sequence_id), 0) = NVL (p_sequence_id, 0)

Line 80: FROM WMS_CAROUSEL_CONFIGURATION

76: P_NAME IN VARCHAR2
77: )
78: IS
79: SELECT CONFIG_VALUE
80: FROM WMS_CAROUSEL_CONFIGURATION
81: WHERE CONFIG_NAME = P_NAME
82: AND DEVICE_TYPE_ID = P_DEVICE_TYPE_ID
83: AND BUSINESS_EVENT_ID = P_BUSINESS_EVENT_ID
84: AND SEQUENCE_ID = P_SEQUENCE_ID

Line 504: FROM wms_carousel_configuration

500: -- Cursor for sequence id's
501: CURSOR c_sequence_ids (p_device_type_id IN NUMBER, P_BUSINESS_EVENT_ID IN NUMBER)
502: IS
503: SELECT sequence_id, config_value
504: FROM wms_carousel_configuration
505: WHERE CONFIG_NAME = 'DIRECTIVE'
506: AND device_type_id = p_device_type_id
507: AND BUSINESS_EVENT_ID = P_BUSINESS_EVENT_ID
508: AND active_ind = 'Y'

Line 1409: FROM WMS_CAROUSEL_CONFIGURATION

1405: AND NVL(q.TASK_ID,0) = NVL(P_TASK_ID,NVL(q.TASK_ID,0))
1406: AND NVL (q.STATUS, 'P') IN ('C', 'P')
1407: AND q.DIRECTIVE IN
1408: (SELECT CONFIG_VALUE
1409: FROM WMS_CAROUSEL_CONFIGURATION
1410: WHERE CONFIG_NAME = NVL(p_config_name,'DIRECTIVE_QUEUE_UPDATE')
1411: AND DEVICE_TYPE_ID = q.DEVICE_TYPE_ID
1412: AND BUSINESS_EVENT_ID = q.BUSINESS_EVENT_ID
1413: AND SEQUENCE_ID = q.SEQUENCE_ID