APPS.WIP_EAM_GENEALOGY_PVT dependencies on MTL_SERIAL_NUMBERS

Line 153: from mtl_serial_numbers

149: else
150: l_serial_number := p_serial_number;
151: l_inventory_item_id := p_inventory_item_id;
152: select current_organization_id into l_organization_id
153: from mtl_serial_numbers
154: where serial_number = l_serial_number
155: and inventory_item_id = l_inventory_item_id;
156: -- l_organization_id := p_organization_id;
157:

Line 164: from mtl_serial_numbers

160: if (p_serial_number is null) or (p_inventory_item_id is null) or (p_organization_id is null) then
161: begin
162: select serial_number, inventory_item_id, current_organization_id
163: into l_serial_number, l_inventory_item_id, l_organization_id
164: from mtl_serial_numbers
165: where gen_object_id = p_object_id;
166: exception
167: when others then
168: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');

Line 176: from mtl_serial_numbers

172: else
173: l_serial_number := p_serial_number;
174: l_inventory_item_id := p_inventory_item_id;
175: select current_organization_id into l_organization_id
176: from mtl_serial_numbers
177: where gen_object_id = p_object_id;
178: --l_organization_id := p_organization_id;
179: end if;
180:

Line 199: from mtl_serial_numbers

195: l_parent_inventory_item_id := p_parent_inventory_item_id;
196:
197: select gen_object_id, current_organization_id
198: into l_parent_object_id, l_parent_organization_id
199: from mtl_serial_numbers
200: where serial_number = l_parent_serial_number
201: and inventory_item_id = p_parent_inventory_item_id;
202: exception
203: when others then

Line 217: from mtl_serial_numbers

213: into
214: l_parent_organization_id,
215: l_parent_serial_number,
216: l_parent_inventory_item_id
217: from mtl_serial_numbers
218: where gen_object_id = l_parent_object_id;
219:
220: end if;
221:

Line 227: from wip_discrete_jobs wdj, mtl_serial_numbers msn

223:
224: begin
225: select msn.gen_object_id
226: into l_charge_object_id
227: from wip_discrete_jobs wdj, mtl_serial_numbers msn
228: where wdj.rebuild_serial_number = l_serial_number
229: and wdj.rebuild_item_id = l_inventory_item_id
230: and wdj.organization_id = l_organization_id
231: and msn.serial_number = wdj.asset_number

Line 509: from mtl_serial_numbers

505:
506:
507: begin
508: select gen_object_id,current_organization_id into l_object_id, l_organization_id
509: from mtl_serial_numbers
510: where serial_number = l_serial_number
511: and inventory_item_id = p_inventory_item_id;
512:
513: exception

Line 530: from mtl_serial_numbers where

526:
527: begin
528: select serial_number, inventory_item_id, current_organization_id
529: into l_serial_number, l_inventory_item_id, l_organization_id
530: from mtl_serial_numbers where
531: gen_object_id = p_object_id;
532:
533: exception
534: when others then

Line 545: from mtl_serial_numbers

541: l_serial_number := p_serial_number;
542: l_inventory_item_id := p_inventory_item_id;
543: --l_organization_id := p_organization_id;
544: select current_organization_id into l_organization_id
545: from mtl_serial_numbers
546: where gen_object_id = p_object_id;
547:
548: end if;
549:

Line 622: from mtl_serial_numbers

618:
619: if p_locator_id is null then
620: begin
621: select current_locator_id into l_locator_id
622: from mtl_serial_numbers
623: where serial_number = l_serial_number and
624: inventory_item_id = l_inventory_item_id and
625: current_organization_id = l_organization_id;
626:

Line 685: from mtl_serial_numbers

681: end if;
682:
683: --obtain the revision of the object from MSN
684: select revision into l_revision
685: from mtl_serial_numbers
686: where serial_number = l_serial_number and
687: inventory_item_id = l_inventory_item_id and
688: current_organization_id = l_organization_id;
689:

Line 712: from mtl_serial_numbers

708: x_statement => l_statement);
709:
710: select last_transaction_id
711: into l_txn_id
712: from mtl_serial_numbers
713: where serial_number = l_serial_number
714: and current_organization_id = l_organization_id and
715: inventory_item_id = l_inventory_item_id;
716:

Line 773: FROM csi_item_instances cii, mtl_serial_numbers msn

769: AND cii.last_vld_organization_id= l_organization_id ;
770:
771: SELECT cii.instance_number ,cii.instance_id
772: INTO l_reference, l_parent_instance_id
773: FROM csi_item_instances cii, mtl_serial_numbers msn
774: WHERE cii.serial_number = msn.serial_number
775: AND cii.inventory_item_id = msn.inventory_item_id
776: AND cii.last_vld_organization_id = msn.current_organization_id
777: AND msn.gen_object_id= l_parent_object_id ;

Line 812: FROM csi_item_instances cii, mtl_serial_numbers msn

808: --Remove Child Event from parent - 16
809: begin
810: SELECT cii.instance_id, cii.instance_number
811: INTO l_parent_instance_id, l_parent_instance_number
812: FROM csi_item_instances cii, mtl_serial_numbers msn
813: WHERE cii.serial_number = msn.serial_number
814: AND cii.inventory_item_id = msn.inventory_item_id
815: AND msn.gen_object_id = l_parent_object_id;
816: