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 1112: FROM DUAL

1108: 'NONE' EQP_INS,
1109: 'NONE'eqp_name,
1110: 'NONE' EQP_DESC,
1111: -999 eqp_id
1112: FROM DUAL
1113: where 'NONE' like (upper(p_concat_segments));
1114:
1115:
1116: END get_eqp_lov;

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

1138: WHERE SUBINVENTORY_CODE is not null
1139: and ORGANIZATION_ID = p_Organization_Id
1140: and NAME like (p_concat_segments)
1141: UNION ALL
1142: SELECT 'NONE' device_name,'NONE' device_type,'NONE'device_desc,-999 EQP_ID,'NONE' SUBINVENTORY FROM DUAL
1143: where 'NONE' like (upper(p_concat_segments))
1144: ORDER BY 1;
1145:
1146:

Line 1278: NVL(dual_uom_deviation_high,0),

1274: NVL(lot_divisible_flag,'Y'),
1275: NVL(secondary_uom_code,''),
1276: NVL(secondary_default_ind,''),
1277: NVL(tracking_quantity_ind,'P'),
1278: NVL(dual_uom_deviation_high,0),
1279: NVL(dual_uom_deviation_low,0)
1280: FROM mtl_system_items_vl /* Bug 5581528 */
1281: WHERE organization_id = p_organization_id
1282: AND concatenated_segments LIKE p_concatenated_segments || l_append

Line 1279: NVL(dual_uom_deviation_low,0)

1275: NVL(secondary_uom_code,''),
1276: NVL(secondary_default_ind,''),
1277: NVL(tracking_quantity_ind,'P'),
1278: NVL(dual_uom_deviation_high,0),
1279: NVL(dual_uom_deviation_low,0)
1280: FROM mtl_system_items_vl /* Bug 5581528 */
1281: WHERE organization_id = p_organization_id
1282: AND concatenated_segments LIKE p_concatenated_segments || l_append
1283:

Line 1326: NVL(dual_uom_deviation_high,0),

1322: NVL(lot_divisible_flag,'Y'),
1323: NVL(secondary_uom_code,''),
1324: NVL(secondary_default_ind,''),
1325: NVL(tracking_quantity_ind,'P'),
1326: NVL(dual_uom_deviation_high,0),
1327: NVL(dual_uom_deviation_low,0)
1328: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1329: mtl_cross_references mcr
1330: WHERE msik.organization_id = p_organization_id

Line 1327: NVL(dual_uom_deviation_low,0)

1323: NVL(secondary_uom_code,''),
1324: NVL(secondary_default_ind,''),
1325: NVL(tracking_quantity_ind,'P'),
1326: NVL(dual_uom_deviation_high,0),
1327: NVL(dual_uom_deviation_low,0)
1328: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1329: mtl_cross_references mcr
1330: WHERE msik.organization_id = p_organization_id
1331: AND msik.inventory_item_id = mcr.inventory_item_id

Line 1383: NVL(dual_uom_deviation_high,0),

1379: NVL(lot_divisible_flag,'Y'),
1380: NVL(secondary_uom_code,''),
1381: NVL(secondary_default_ind,''),
1382: NVL(tracking_quantity_ind,'P'),
1383: NVL(dual_uom_deviation_high,0),
1384: NVL(dual_uom_deviation_low,0)
1385: FROM mtl_system_items_vl msik /* Bug 5581528 */
1386: WHERE organization_id = p_organization_id
1387: AND concatenated_segments LIKE p_concatenated_segments||l_append

Line 1384: NVL(dual_uom_deviation_low,0)

1380: NVL(secondary_uom_code,''),
1381: NVL(secondary_default_ind,''),
1382: NVL(tracking_quantity_ind,'P'),
1383: NVL(dual_uom_deviation_high,0),
1384: NVL(dual_uom_deviation_low,0)
1385: FROM mtl_system_items_vl msik /* Bug 5581528 */
1386: WHERE organization_id = p_organization_id
1387: AND concatenated_segments LIKE p_concatenated_segments||l_append
1388: AND exists

Line 1436: NVL(dual_uom_deviation_high,0),

1432: NVL(lot_divisible_flag,'Y'),
1433: NVL(secondary_uom_code,''),
1434: NVL(secondary_default_ind,''),
1435: NVL(tracking_quantity_ind,'P'),
1436: NVL(dual_uom_deviation_high,0),
1437: NVL(dual_uom_deviation_low,0)
1438: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1439: mtl_cross_references mcr
1440: WHERE msik.organization_id = p_organization_id

Line 1437: NVL(dual_uom_deviation_low,0)

1433: NVL(secondary_uom_code,''),
1434: NVL(secondary_default_ind,''),
1435: NVL(tracking_quantity_ind,'P'),
1436: NVL(dual_uom_deviation_high,0),
1437: NVL(dual_uom_deviation_low,0)
1438: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1439: mtl_cross_references mcr
1440: WHERE msik.organization_id = p_organization_id
1441: AND msik.inventory_item_id = mcr.inventory_item_id