APPS.INV_CYC_SERIALS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 41: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

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

Line 98: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

94: 0,
95: msn.current_status,
96: mms.status_code
97: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
98: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
99: WHERE msn.inventory_item_id = p_inventory_item_id
100: AND msn.group_mark_id = 1
101: AND msn.current_organization_id = p_organization_id
102: AND msn.current_status IN (1, 3)

Line 154: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

150: AND current_organization_id = p_organization_id
151: AND serial_number IN
152: (SELECT UNIQUE msn.serial_number
153: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
154: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
155: WHERE msn.inventory_item_id = p_inventory_item_id
156: AND msn.current_organization_id = p_organization_id
157: AND msn.current_status IN (1, 3)
158: AND msn.status_id = mms.status_id(+)

Line 220: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

216: AND current_organization_id = p_organization_id
217: AND serial_number IN
218: (SELECT UNIQUE msn.serial_number
219: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
220: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
221: WHERE msn.inventory_item_id = p_inventory_item_id
222: AND msn.current_organization_id = p_organization_id
223: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list and commented below check
224: --OR (msn.last_txn_source_type_id in (9,10) AND msn.current_status = 4)) --Bug# 3595723 Bug11875440

Line 307: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

303: AND current_organization_id = p_organization_id
304: AND serial_number IN
305: (SELECT UNIQUE msn.serial_number
306: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
307: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
308: WHERE msn.inventory_item_id = p_inventory_item_id
309: AND msn.current_organization_id = p_organization_id
310: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list
311: AND msn.status_id = mms.status_id(+)

Line 379: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

375: AND current_organization_id = p_organization_id
376: AND serial_number IN
377: (SELECT UNIQUE msn.serial_number
378: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
379: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
380: WHERE msn.inventory_item_id = p_inventory_item_id
381: AND msn.current_organization_id = p_organization_id
382: AND msn.current_status IN (1, 3)
383: AND msn.status_id = mms.status_id(+)

Line 434: -- of the cycle count entry (based on column values in MTL_CYCLE_COUNT_ENTRIES table)

430:
431: -- Difference between this procedure and mark_all_present procedure defined above
432: -- Here we are Updating group_mark_id to 1 for only those serials which are
433: -- in the same sub/loc (based on columns in MTL_SERIAL_NUMBERS table) as the sub/loc
434: -- of the cycle count entry (based on column values in MTL_CYCLE_COUNT_ENTRIES table)
435:
436: UPDATE mtl_serial_numbers
437: SET group_mark_id = 1
438: WHERE inventory_item_id = p_inventory_item_id

Line 443: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

439: AND current_organization_id = p_organization_id
440: AND serial_number IN
441: (SELECT UNIQUE msn.serial_number
442: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
443: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
444: WHERE msn.inventory_item_id = p_inventory_item_id
445: AND msn.current_organization_id = p_organization_id
446: AND msn.current_status IN (1, 3)
447: AND msn.status_id = mms.status_id(+)

Line 498: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

494: BEGIN
495: SELECT COUNT(*)
496: INTO x_number
497: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
498: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
499: WHERE msn.inventory_item_id = p_inventory_item_id
500: AND msn.group_mark_id = 1
501: AND msn.current_organization_id = p_organization_id
502: AND msn.current_status IN (1, 3)

Line 661: FROM mtl_cycle_count_entries

657: IF (NVL(p_parent_lpn_id,0) = 0 ) THEN --No LPN passed
658: /* Get the cycle count entry id and approval_condition */
659: SELECT cycle_count_entry_id, approval_condition
660: INTO l_cycle_count_entry_id , l_approval_condition
661: FROM mtl_cycle_count_entries
662: WHERE cycle_count_header_id = p_cycle_count_header_id
663: AND entry_status_code IN (1,3)
664: AND inventory_item_id = p_inventory_item_id
665: AND organization_id = p_organization_id

Line 674: FROM mtl_cycle_count_entries

670: AND nvl(parent_lpn_id,-999) = -999;
671: ELSE
672: SELECT cycle_count_entry_id, approval_condition
673: INTO l_cycle_count_entry_id , l_approval_condition
674: FROM mtl_cycle_count_entries
675: WHERE cycle_count_header_id = p_cycle_count_header_id
676: AND entry_status_code IN (1,3)
677: AND inventory_item_id = p_inventory_item_id
678: AND organization_id = p_organization_id

Line 984: FROM mtl_cycle_count_entries

980:
981: /* Get the cycle count entry id */
982: SELECT cycle_count_entry_id
983: INTO l_cycle_count_entry_id
984: FROM mtl_cycle_count_entries
985: WHERE cycle_count_header_id = p_cycle_count_header_id
986: AND entry_status_code IN (1,3)
987: AND inventory_item_id = p_inventory_item_id
988: AND organization_id = p_organization_id