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 1095: mtl_serial_numbers.serial_number EQP_INS,

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

Line 1098: mtl_serial_numbers.inventory_item_id EQP_ID

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

Line 1100: mtl_serial_numbers,

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

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

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