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 506: from mtl_serial_numbers

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

Line 527: from mtl_serial_numbers where

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

Line 542: from mtl_serial_numbers

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

Line 619: from mtl_serial_numbers

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

Line 656: from mtl_serial_numbers

652: end if;
653:
654: --obtain the revision of the object from MSN
655: select revision into l_revision
656: from mtl_serial_numbers
657: where serial_number = l_serial_number and
658: inventory_item_id = l_inventory_item_id and
659: current_organization_id = l_organization_id;
660:

Line 683: from mtl_serial_numbers

679: x_statement => l_statement);
680:
681: select last_transaction_id
682: into l_txn_id
683: from mtl_serial_numbers
684: where serial_number = l_serial_number
685: and current_organization_id = l_organization_id and
686: inventory_item_id = l_inventory_item_id;
687:

Line 744: FROM csi_item_instances cii, mtl_serial_numbers msn

740: AND cii.last_vld_organization_id= l_organization_id ;
741:
742: SELECT cii.instance_number ,cii.instance_id
743: INTO l_reference, l_parent_instance_id
744: FROM csi_item_instances cii, mtl_serial_numbers msn
745: WHERE cii.serial_number = msn.serial_number
746: AND cii.inventory_item_id = msn.inventory_item_id
747: AND cii.last_vld_organization_id = msn.current_organization_id
748: AND msn.gen_object_id= l_parent_object_id ;

Line 783: FROM csi_item_instances cii, mtl_serial_numbers msn

779: --Remove Child Event from parent - 16
780: begin
781: SELECT cii.instance_id, cii.instance_number
782: INTO l_parent_instance_id, l_parent_instance_number
783: FROM csi_item_instances cii, mtl_serial_numbers msn
784: WHERE cii.serial_number = msn.serial_number
785: AND cii.inventory_item_id = msn.inventory_item_id
786: AND msn.gen_object_id = l_parent_object_id;
787: