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.INV_CYC_SERIALS dependencies on MTL_MATERIAL_STATUSES_VL

Line 43: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

39: 0,
40: msn.current_status,
41: mms.status_code
42: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
43: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
44: WHERE msn.inventory_item_id = p_inventory_item_id
45: AND msn.current_organization_id = p_organization_id
46: AND msn.current_status IN (1, 3)
47: AND msn.status_id = mms.status_id(+)

Line 88: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

84: 0,
85: msn.current_status,
86: mms.status_code
87: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
88: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
89: WHERE msn.inventory_item_id = p_inventory_item_id
90: AND msn.group_mark_id = 1
91: AND msn.current_organization_id = p_organization_id
92: AND msn.current_status IN (1, 3)

Line 132: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

128: AND current_organization_id = p_organization_id
129: AND serial_number IN
130: (SELECT UNIQUE msn.serial_number
131: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
132: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
133: WHERE msn.inventory_item_id = p_inventory_item_id
134: AND msn.current_organization_id = p_organization_id
135: AND msn.current_status IN (1, 3)
136: AND msn.status_id = mms.status_id(+)

Line 185: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

181: AND current_organization_id = p_organization_id
182: AND serial_number IN
183: (SELECT UNIQUE msn.serial_number
184: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
185: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
186: WHERE msn.inventory_item_id = p_inventory_item_id
187: AND msn.current_organization_id = p_organization_id
188: AND ( msn.current_status IN (1, 3)
189: OR (msn.last_txn_source_type_id = 9 AND msn.current_status = 4)) --Bug# 3595723

Line 259: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

255: AND current_organization_id = p_organization_id
256: AND serial_number IN
257: (SELECT UNIQUE msn.serial_number
258: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
259: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
260: WHERE msn.inventory_item_id = p_inventory_item_id
261: AND msn.current_organization_id = p_organization_id
262: AND msn.current_status IN (1, 3)
263: AND msn.status_id = mms.status_id(+)

Line 318: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

314: AND current_organization_id = p_organization_id
315: AND serial_number IN
316: (SELECT UNIQUE msn.serial_number
317: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
318: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
319: WHERE msn.inventory_item_id = p_inventory_item_id
320: AND msn.current_organization_id = p_organization_id
321: AND msn.current_status IN (1, 3)
322: AND msn.status_id = mms.status_id(+)

Line 356: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

352: BEGIN
353: SELECT COUNT(*)
354: INTO x_number
355: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
356: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
357: WHERE msn.inventory_item_id = p_inventory_item_id
358: AND msn.group_mark_id = 1
359: AND msn.current_organization_id = p_organization_id
360: AND msn.current_status IN (1, 3)