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 765: FROM csi_item_instances cii, mtl_parameters mp

761: --Remove Parent Instance from Child Instance - 17
762: begin
763: SELECT cii.instance_id, mp.maint_organization_id
764: INTO l_instance_id , l_maint_orgid
765: FROM csi_item_instances cii, mtl_parameters mp
766: WHERE cii.serial_number = l_serial_number
767: AND cii.inventory_item_id = l_inventory_item_id
768: AND cii.last_vld_organization_id = mp.organization_id
769: AND cii.last_vld_organization_id= l_organization_id ;

Line 916: x_neg_flag,x_org_ctrl FROM MTL_PARAMETERS

912: -- retrive organization level control information
913: Begin
914: SELECT
915: negative_inv_receipt_code,stock_locator_control_code into
916: x_neg_flag,x_org_ctrl FROM MTL_PARAMETERS
917: WHERE
918: organization_id = p_org;
919: Exception
920: When no_data_found then