APPS.MTL_PARAM_VALIDATE_PKG dependencies on MTL_SERIAL_NUMBERS

Line 110: from mtl_serial_numbers

106: l_ser_num VARCHAR2(30);
107: l_ser_count NUMBER;
108: cursor ser_config(p_org_id number) is
109: select serial_number,count(*)
110: from mtl_serial_numbers
111: where inventory_item_id in (select inventory_item_id
112: from mtl_system_items_b
113: where organization_id = p_org_id
114: and serial_number_control_code <> 1

Line 157: from mtl_serial_numbers a,

153: elsif curr_serial_control = 2 then -- With in Org
154: BEGIN
155: select 'uniqueness violated'
156: into v_garbage
157: from mtl_serial_numbers a,
158: mtl_serial_numbers b
159: where a.serial_number = b.serial_number
160: and a.current_organization_id = org_id
161: and b.current_organization_id = org_id

Line 158: mtl_serial_numbers b

154: BEGIN
155: select 'uniqueness violated'
156: into v_garbage
157: from mtl_serial_numbers a,
158: mtl_serial_numbers b
159: where a.serial_number = b.serial_number
160: and a.current_organization_id = org_id
161: and b.current_organization_id = org_id
162: and a.inventory_item_id <> b.inventory_item_id

Line 192: --from mtl_serial_numbers a,

188: elsif curr_serial_control = 3 then -- Across Org
189: --Bug 5263266 Modified the below sql for performance issues.
190: --select 'uniqueness violated'
191: --into v_garbage
192: --from mtl_serial_numbers a,
193: -- mtl_serial_numbers b
194: --where a.serial_number = b.serial_number
195: --and a.current_organization_id <>
196: -- b.current_organization_id

Line 193: -- mtl_serial_numbers b

189: --Bug 5263266 Modified the below sql for performance issues.
190: --select 'uniqueness violated'
191: --into v_garbage
192: --from mtl_serial_numbers a,
193: -- mtl_serial_numbers b
194: --where a.serial_number = b.serial_number
195: --and a.current_organization_id <>
196: -- b.current_organization_id
197: --and rownum < 2;

Line 203: from mtl_serial_numbers a

199:
200: /* Commented following query for bug 9945449 as form used to hang at this SQL
201: select 'uniqueness violated'
202: into v_garbage
203: from mtl_serial_numbers a
204: where exists ( select 1
205: from mtl_serial_numbers b
206: where a.serial_number = b.serial_number
207: and a.current_organization_id <> b.current_organization_id )

Line 205: from mtl_serial_numbers b

201: select 'uniqueness violated'
202: into v_garbage
203: from mtl_serial_numbers a
204: where exists ( select 1
205: from mtl_serial_numbers b
206: where a.serial_number = b.serial_number
207: and a.current_organization_id <> b.current_organization_id )
208: and rownum < 2;
209: */

Line 218: where exists (select 1 from mtl_serial_numbers a, mtl_serial_numbers b

214:
215: /*select 'uniqueness violated'
216: into v_garbage
217: from dual
218: where exists (select 1 from mtl_serial_numbers a, mtl_serial_numbers b
219: where a.serial_number = b.serial_number
220: and a.current_organization_id <> b.current_organization_id);
221:
222: v_return_val := 2;

Line 229: from mtl_serial_numbers a,

225: WHEN NO_DATA_FOUND THEN
226: BEGIN
227: select 'uniqueness violated'
228: into v_garbage
229: from mtl_serial_numbers a,
230: mtl_serial_numbers b
231: where a.serial_number = b.serial_number
232: and a.current_organization_id = org_id
233: and b.current_organization_id = org_id

Line 230: mtl_serial_numbers b

226: BEGIN
227: select 'uniqueness violated'
228: into v_garbage
229: from mtl_serial_numbers a,
230: mtl_serial_numbers b
231: where a.serial_number = b.serial_number
232: and a.current_organization_id = org_id
233: and b.current_organization_id = org_id
234: and a.inventory_item_id <> b.inventory_item_id

Line 251: from mtl_serial_numbers

247: from dual
248: where
249: exists (
250: select serial_number, count(1)
251: from mtl_serial_numbers
252: group by serial_number
253: having count(1) > 1
254: );
255:

Line 263: from mtl_serial_numbers

259: from dual
260: where
261: exists (
262: select serial_number, count(1)
263: from mtl_serial_numbers
264: group by serial_number, current_organization_id
265: having count(1) > 1
266: );
267: v_return_val := 0;