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 193: --from mtl_serial_numbers a,

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

Line 194: -- mtl_serial_numbers b

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

Line 202: from mtl_serial_numbers a

198: --and rownum < 2;
199: --Modified SQL
200: select 'uniqueness violated'
201: into v_garbage
202: from mtl_serial_numbers a
203: where exists ( select 1
204: from mtl_serial_numbers b
205: where a.serial_number = b.serial_number
206: and a.current_organization_id <> b.current_organization_id )

Line 204: from mtl_serial_numbers b

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

Line 216: from mtl_serial_numbers a,

212: WHEN NO_DATA_FOUND THEN
213: BEGIN
214: select 'uniqueness violated'
215: into v_garbage
216: from mtl_serial_numbers a,
217: mtl_serial_numbers b
218: where a.serial_number = b.serial_number
219: and a.current_organization_id = org_id
220: and b.current_organization_id = org_id

Line 217: mtl_serial_numbers b

213: BEGIN
214: select 'uniqueness violated'
215: into v_garbage
216: from mtl_serial_numbers a,
217: mtl_serial_numbers b
218: where a.serial_number = b.serial_number
219: and a.current_organization_id = org_id
220: and b.current_organization_id = org_id
221: and a.inventory_item_id <> b.inventory_item_id