APPS.INV_MATERIAL_STATUS_PKG dependencies on DUAL

Line 15: from dual

11: BEGIN
12: -- Check subinventories
13: select 1
14: into count_assigned
15: from dual
16: where exists (select 1
17: from mtl_secondary_inventories
18: where status_id = p_status_id);
19:

Line 30: from dual

26: BEGIN
27: -- Check locator
28: select 1
29: into count_assigned
30: from dual
31: where exists (select 1
32: from mtl_item_locations
33: where status_id = p_status_id);
34:

Line 44: from dual

40: BEGIN
41: -- Check lot
42: select 1
43: into count_assigned
44: from dual
45: where exists (select 1
46: from mtl_lot_numbers
47: where status_id = p_status_id);
48:

Line 58: from dual

54: BEGIN
55: -- Check serial
56: select 1
57: into count_assigned
58: from dual
59: where exists (select 1
60: from mtl_serial_numbers
61: where status_id = p_status_id);
62:

Line 72: from dual

68: BEGIN
69: -- Check Onhand -- Bug 6842219
70: select 1
71: into count_assigned
72: from dual
73: where exists (select 1
74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp
75: where moqd.organization_id = mp.organization_id
76: and mp.default_status_id is not null

Line 266: From dual;

262: BEGIN
263: --BEGIN SCHANDRU INVERES
264: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
265: Into l_status_update_id
266: From dual;
267: -- END SCHANDRU INVERES
268: l_status_rec := p_status_rec;
269: INV_MATERIAL_STATUS_PKG.Initialize_status_rec(l_status_rec);
270:

Line 380: From dual;

376: FOR cc IN cur_serial_number LOOP
377: -- BEGIN SCHANDRU INVERES
378: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
379: Into l_status_update_id
380: From dual;
381:
382: -- END SCHANDRU INVERES
383: INSERT INTO MTL_MATERIAL_STATUS_HISTORY
384: (