DBA Data[Home] [Help]

APPS.WIP_EAM_GENEALOGY_PVT dependencies on MTL_PARAMETERS

Line 287: FROM csi_item_instances cii, mtl_parameters mp

283: begin
284:
285: SELECT cii.instance_id, mp.maint_organization_id,cii.instance_number
286: INTO l_parent_instance_id , l_maint_orgid,l_parent_instance_number
287: FROM csi_item_instances cii, mtl_parameters mp
288: WHERE cii.serial_number = l_parent_serial_number
289: AND cii.inventory_item_id = l_parent_inventory_item_id
290: AND cii.last_vld_organization_id = mp.organization_id
291: AND cii.last_vld_organization_id= l_organization_id ;

Line 736: FROM csi_item_instances cii, mtl_parameters mp

732: --Remove Parent Instance from Child Instance - 17
733: begin
734: SELECT cii.instance_id, mp.maint_organization_id
735: INTO l_instance_id , l_maint_orgid
736: FROM csi_item_instances cii, mtl_parameters mp
737: WHERE cii.serial_number = l_serial_number
738: AND cii.inventory_item_id = l_inventory_item_id
739: AND cii.last_vld_organization_id = mp.organization_id
740: AND cii.last_vld_organization_id= l_organization_id ;