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 MTL_SYSTEM_ITEMS_VL

Line 1026: FROM mtl_material_transactions_temp m, mtl_system_items_vl k

1022: BEGIN
1023:
1024: OPEN x_items FOR
1025: SELECT k.concatenated_segments, k.inventory_item_id
1026: FROM mtl_material_transactions_temp m, mtl_system_items_vl k
1027: WHERE m.transfer_lpn_id=p_lpn_id
1028: AND m.organization_id=k.organization_id
1029: AND m.inventory_item_id=k.inventory_item_id
1030: AND k.concatenated_segments LIKE (p_concat_segments);

Line 1044: FROM mtl_system_items_vl k

1040: BEGIN
1041:
1042: OPEN x_container_items FOR
1043: SELECT k.concatenated_segments, k.inventory_item_id
1044: FROM mtl_system_items_vl k
1045: WHERE k.organization_id=p_org_id
1046: AND k.container_item_flag='Y'
1047: AND k.concatenated_segments LIKE (p_concat_segments);
1048: mydebug('In get_container_items_lov');

Line 1096: mtl_system_items_vl.concatenated_segments EQP_NAME,

1092:
1093: OPEN x_eqps FOR
1094: SELECT
1095: mtl_serial_numbers.serial_number EQP_INS,
1096: mtl_system_items_vl.concatenated_segments EQP_NAME,
1097: mtl_system_items_vl.description EQP_DESC ,
1098: mtl_serial_numbers.inventory_item_id EQP_ID
1099: from
1100: mtl_serial_numbers,

Line 1097: mtl_system_items_vl.description EQP_DESC ,

1093: OPEN x_eqps FOR
1094: SELECT
1095: mtl_serial_numbers.serial_number EQP_INS,
1096: mtl_system_items_vl.concatenated_segments EQP_NAME,
1097: mtl_system_items_vl.description EQP_DESC ,
1098: mtl_serial_numbers.inventory_item_id EQP_ID
1099: from
1100: mtl_serial_numbers,
1101: mtl_system_items_vl /* Bug 5581528 */

Line 1101: mtl_system_items_vl /* Bug 5581528 */

1097: mtl_system_items_vl.description EQP_DESC ,
1098: mtl_serial_numbers.inventory_item_id EQP_ID
1099: from
1100: mtl_serial_numbers,
1101: mtl_system_items_vl /* Bug 5581528 */
1102: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1103: and mtl_system_items_vl.organization_id=p_Organization_Id
1104: and mtl_system_items_vl.equipment_type=1
1105: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)

Line 1102: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id

1098: mtl_serial_numbers.inventory_item_id EQP_ID
1099: from
1100: mtl_serial_numbers,
1101: mtl_system_items_vl /* Bug 5581528 */
1102: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1103: and mtl_system_items_vl.organization_id=p_Organization_Id
1104: and mtl_system_items_vl.equipment_type=1
1105: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)
1106: UNION ALL

Line 1103: and mtl_system_items_vl.organization_id=p_Organization_Id

1099: from
1100: mtl_serial_numbers,
1101: mtl_system_items_vl /* Bug 5581528 */
1102: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1103: and mtl_system_items_vl.organization_id=p_Organization_Id
1104: and mtl_system_items_vl.equipment_type=1
1105: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)
1106: UNION ALL
1107: SELECT

Line 1104: and mtl_system_items_vl.equipment_type=1

1100: mtl_serial_numbers,
1101: mtl_system_items_vl /* Bug 5581528 */
1102: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1103: and mtl_system_items_vl.organization_id=p_Organization_Id
1104: and mtl_system_items_vl.equipment_type=1
1105: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)
1106: UNION ALL
1107: SELECT
1108: 'NONE' EQP_INS,

Line 1280: FROM mtl_system_items_vl /* Bug 5581528 */

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:
1284: --Changes for GTIN

Line 1328: FROM mtl_system_items_vl msik, /* Bug 5581528 */

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
1332: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 1385: FROM mtl_system_items_vl msik /* Bug 5581528 */

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
1389: ( select 1

Line 1438: FROM mtl_system_items_vl msik, /* Bug 5581528 */

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
1442: AND mcr.cross_reference_type = g_gtin_cross_ref_type