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 956: FROM mtl_material_transactions_temp m, mtl_system_items_vl k

952: BEGIN
953:
954: OPEN x_items FOR
955: SELECT k.concatenated_segments, k.inventory_item_id
956: FROM mtl_material_transactions_temp m, mtl_system_items_vl k
957: WHERE m.transfer_lpn_id=p_lpn_id
958: AND m.organization_id=k.organization_id
959: AND m.inventory_item_id=k.inventory_item_id
960: AND k.concatenated_segments LIKE (p_concat_segments);

Line 974: FROM mtl_system_items_vl k

970: BEGIN
971:
972: OPEN x_container_items FOR
973: SELECT k.concatenated_segments, k.inventory_item_id
974: FROM mtl_system_items_vl k
975: WHERE k.organization_id=p_org_id
976: AND k.container_item_flag='Y'
977: AND k.concatenated_segments LIKE (p_concat_segments);
978: mydebug('In get_container_items_lov');

Line 1026: mtl_system_items_vl.concatenated_segments EQP_NAME,

1022:
1023: OPEN x_eqps FOR
1024: SELECT
1025: mtl_serial_numbers.serial_number EQP_INS,
1026: mtl_system_items_vl.concatenated_segments EQP_NAME,
1027: mtl_system_items_vl.description EQP_DESC ,
1028: mtl_serial_numbers.inventory_item_id EQP_ID
1029: from
1030: mtl_serial_numbers,

Line 1027: mtl_system_items_vl.description EQP_DESC ,

1023: OPEN x_eqps FOR
1024: SELECT
1025: mtl_serial_numbers.serial_number EQP_INS,
1026: mtl_system_items_vl.concatenated_segments EQP_NAME,
1027: mtl_system_items_vl.description EQP_DESC ,
1028: mtl_serial_numbers.inventory_item_id EQP_ID
1029: from
1030: mtl_serial_numbers,
1031: mtl_system_items_vl /* Bug 5581528 */

Line 1031: mtl_system_items_vl /* Bug 5581528 */

1027: mtl_system_items_vl.description EQP_DESC ,
1028: mtl_serial_numbers.inventory_item_id EQP_ID
1029: from
1030: mtl_serial_numbers,
1031: mtl_system_items_vl /* Bug 5581528 */
1032: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1033: and mtl_system_items_vl.organization_id=p_Organization_Id
1034: and mtl_system_items_vl.equipment_type=1
1035: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)

Line 1032: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id

1028: mtl_serial_numbers.inventory_item_id EQP_ID
1029: from
1030: mtl_serial_numbers,
1031: mtl_system_items_vl /* Bug 5581528 */
1032: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1033: and mtl_system_items_vl.organization_id=p_Organization_Id
1034: and mtl_system_items_vl.equipment_type=1
1035: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)
1036: UNION ALL

Line 1033: and mtl_system_items_vl.organization_id=p_Organization_Id

1029: from
1030: mtl_serial_numbers,
1031: mtl_system_items_vl /* Bug 5581528 */
1032: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1033: and mtl_system_items_vl.organization_id=p_Organization_Id
1034: and mtl_system_items_vl.equipment_type=1
1035: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)
1036: UNION ALL
1037: SELECT

Line 1034: and mtl_system_items_vl.equipment_type=1

1030: mtl_serial_numbers,
1031: mtl_system_items_vl /* Bug 5581528 */
1032: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id
1033: and mtl_system_items_vl.organization_id=p_Organization_Id
1034: and mtl_system_items_vl.equipment_type=1
1035: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)
1036: UNION ALL
1037: SELECT
1038: 'NONE' EQP_INS,

Line 1206: FROM mtl_system_items_vl /* Bug 5581528 */

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

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

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

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

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

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

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