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_CYCLE_COUNT_ENTRIES

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)

Line 433: FROM mtl_cycle_count_entries

429:
430: /* Get the cycle count entry id and approval_condition */
431: SELECT cycle_count_entry_id, approval_condition
432: INTO l_cycle_count_entry_id , l_approval_condition
433: FROM mtl_cycle_count_entries
434: WHERE cycle_count_header_id = p_cycle_count_header_id
435: AND entry_status_code IN (1,3)
436: AND inventory_item_id = p_inventory_item_id
437: AND organization_id = p_organization_id

Line 597: FROM mtl_cycle_count_entries

593:
594: /* Get the cycle count entry id */
595: SELECT cycle_count_entry_id
596: INTO l_cycle_count_entry_id
597: FROM mtl_cycle_count_entries
598: WHERE cycle_count_header_id = p_cycle_count_header_id
599: AND entry_status_code IN (1,3)
600: AND inventory_item_id = p_inventory_item_id
601: AND organization_id = p_organization_id