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_TASK_DISPATCH_LOV dependencies on DUAL

Line 17: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

13: IS
14: l_msg VARCHAR2(5100);
15: l_ts VARCHAR2(30);
16: BEGIN
17: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
18: -- l_msg:=l_ts||' '||msg;
19:
20: l_msg := msg;
21:

Line 1042: FROM DUAL

1038: 'NONE' EQP_INS,
1039: 'NONE'eqp_name,
1040: 'NONE' EQP_DESC,
1041: -999 eqp_id
1042: FROM DUAL
1043: where 'NONE' like (upper(p_concat_segments));
1044:
1045:
1046: END get_eqp_lov;

Line 1072: SELECT 'NONE' device_name,'NONE' device_type,'NONE'device_desc,-999 EQP_ID,'NONE' SUBINVENTORY FROM DUAL

1068: WHERE SUBINVENTORY_CODE is not null
1069: and ORGANIZATION_ID = p_Organization_Id
1070: and NAME like (p_concat_segments)
1071: UNION ALL
1072: SELECT 'NONE' device_name,'NONE' device_type,'NONE'device_desc,-999 EQP_ID,'NONE' SUBINVENTORY FROM DUAL
1073: where 'NONE' like (upper(p_concat_segments))
1074: ORDER BY 1;
1075:
1076:

Line 1204: NVL(dual_uom_deviation_high,0),

1200: NVL(lot_divisible_flag,'Y'),
1201: NVL(secondary_uom_code,''),
1202: NVL(secondary_default_ind,''),
1203: NVL(tracking_quantity_ind,'P'),
1204: NVL(dual_uom_deviation_high,0),
1205: NVL(dual_uom_deviation_low,0)
1206: FROM mtl_system_items_vl /* Bug 5581528 */
1207: WHERE organization_id = p_organization_id
1208: AND concatenated_segments LIKE p_concatenated_segments

Line 1205: NVL(dual_uom_deviation_low,0)

1201: NVL(secondary_uom_code,''),
1202: NVL(secondary_default_ind,''),
1203: NVL(tracking_quantity_ind,'P'),
1204: NVL(dual_uom_deviation_high,0),
1205: NVL(dual_uom_deviation_low,0)
1206: FROM mtl_system_items_vl /* Bug 5581528 */
1207: WHERE organization_id = p_organization_id
1208: AND concatenated_segments LIKE p_concatenated_segments
1209:

Line 1251: NVL(dual_uom_deviation_high,0),

1247: NVL(lot_divisible_flag,'Y'),
1248: NVL(secondary_uom_code,''),
1249: NVL(secondary_default_ind,''),
1250: NVL(tracking_quantity_ind,'P'),
1251: NVL(dual_uom_deviation_high,0),
1252: NVL(dual_uom_deviation_low,0)
1253: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1254: mtl_cross_references mcr
1255: WHERE msik.organization_id = p_organization_id

Line 1252: NVL(dual_uom_deviation_low,0)

1248: NVL(secondary_uom_code,''),
1249: NVL(secondary_default_ind,''),
1250: NVL(tracking_quantity_ind,'P'),
1251: NVL(dual_uom_deviation_high,0),
1252: NVL(dual_uom_deviation_low,0)
1253: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1254: mtl_cross_references mcr
1255: WHERE msik.organization_id = p_organization_id
1256: AND msik.inventory_item_id = mcr.inventory_item_id

Line 1307: NVL(dual_uom_deviation_high,0),

1303: NVL(lot_divisible_flag,'Y'),
1304: NVL(secondary_uom_code,''),
1305: NVL(secondary_default_ind,''),
1306: NVL(tracking_quantity_ind,'P'),
1307: NVL(dual_uom_deviation_high,0),
1308: NVL(dual_uom_deviation_low,0)
1309: FROM mtl_system_items_vl msik /* Bug 5581528 */
1310: WHERE organization_id = p_organization_id
1311: AND concatenated_segments LIKE p_concatenated_segments

Line 1308: NVL(dual_uom_deviation_low,0)

1304: NVL(secondary_uom_code,''),
1305: NVL(secondary_default_ind,''),
1306: NVL(tracking_quantity_ind,'P'),
1307: NVL(dual_uom_deviation_high,0),
1308: NVL(dual_uom_deviation_low,0)
1309: FROM mtl_system_items_vl msik /* Bug 5581528 */
1310: WHERE organization_id = p_organization_id
1311: AND concatenated_segments LIKE p_concatenated_segments
1312: AND exists

Line 1359: NVL(dual_uom_deviation_high,0),

1355: NVL(lot_divisible_flag,'Y'),
1356: NVL(secondary_uom_code,''),
1357: NVL(secondary_default_ind,''),
1358: NVL(tracking_quantity_ind,'P'),
1359: NVL(dual_uom_deviation_high,0),
1360: NVL(dual_uom_deviation_low,0)
1361: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1362: mtl_cross_references mcr
1363: WHERE msik.organization_id = p_organization_id

Line 1360: NVL(dual_uom_deviation_low,0)

1356: NVL(secondary_uom_code,''),
1357: NVL(secondary_default_ind,''),
1358: NVL(tracking_quantity_ind,'P'),
1359: NVL(dual_uom_deviation_high,0),
1360: NVL(dual_uom_deviation_low,0)
1361: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1362: mtl_cross_references mcr
1363: WHERE msik.organization_id = p_organization_id
1364: AND msik.inventory_item_id = mcr.inventory_item_id