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_SERIAL_NUMBERS

Line 1025: mtl_serial_numbers.serial_number EQP_INS,

1021: BEGIN
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

Line 1028: mtl_serial_numbers.inventory_item_id EQP_ID

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 */
1032: where mtl_serial_numbers.inventory_item_id=mtl_system_items_vl.inventory_item_id

Line 1030: mtl_serial_numbers,

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 */
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

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 1035: AND mtl_serial_numbers.serial_number LIKE (p_concat_segments)

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,
1039: 'NONE'eqp_name,