[Home] [Help]
420: FROM bom_small_expl_temp bet
421: ,bom_bill_of_materials bom
422: ,mtl_system_items msi
423: ,mtl_system_items msip
424: ,mtl_parameters mp
425: WHERE bet.group_id = p_group_id
426: AND bet.plan_level > 0 -- Ignore Top Most
427: AND bet.component_item_id = msi.inventory_item_id
428: AND bet.organization_id = msi.organization_id
2750: -- Maintenance organization
2751: BEGIN
2752: SELECT maint_organization_id
2753: INTO l_maint_organization_id
2754: FROM mtl_parameters
2755: WHERE organization_id = p_instance_header_tbl(tab_row).vld_organization_id;
2756: EXCEPTION
2757: WHEN NO_DATA_FOUND THEN
2758: NULL;
2762: THEN
2763: BEGIN
2764: SELECT organization_code
2765: INTO p_instance_header_tbl(tab_row).maintenance_organization
2766: FROM mtl_parameters
2767: WHERE organization_id = l_maint_organization_id;
2768: EXCEPTION
2769: WHEN NO_DATA_FOUND THEN
2770: NULL;
4737: --
4738:
4739: --Validations for the Create Item Instance
4740: --If vld_organization_id is passed and inv_master_organization_id is
4741: --not passed then derive master_organization_id from mtl_parameters.
4742: -- Start of modifications by sk on 02/19/02 for bug 2198575
4743: IF ((p_instance_rec.vld_organization_id IS NOT NULL) AND
4744: (p_instance_rec.vld_organization_id <> FND_API.G_MISS_NUM)) AND
4745: ((p_instance_rec.inv_master_organization_id IS NULL) OR
4747: THEN
4748: BEGIN
4749: SELECT master_organization_id
4750: INTO p_instance_rec.inv_master_organization_id
4751: FROM mtl_parameters
4752: WHERE organization_id = p_instance_rec.vld_organization_id;
4753: EXCEPTION
4754: WHEN OTHERS THEN
4755: NULL;
4777: THEN
4778: BEGIN
4779: SELECT 'x'
4780: INTO l_temp
4781: FROM mtl_parameters
4782: WHERE organization_id = p_instance_rec.vld_organization_id
4783: AND master_organization_id = p_instance_rec.inv_master_organization_id;
4784: EXCEPTION
4785: WHEN NO_DATA_FOUND THEN
12698: l_curr_instance_rec.inv_master_organization_id)) THEN
12699: BEGIN
12700: SELECT 'x'
12701: INTO l_temp
12702: FROM mtl_parameters
12703: WHERE organization_id = p_instance_rec.vld_organization_id
12704: AND master_organization_id = p_instance_rec.inv_master_organization_id;
12705: EXCEPTION
12706: WHEN NO_DATA_FOUND THEN
14992: IF l_cur_instance_rec.last_vld_organization_id <> l_get_instance_rec.vld_organization_id
14993: THEN
14994: SELECT maint_organization_id
14995: INTO l_curr_maint_org_id
14996: FROM mtl_parameters
14997: WHERE organization_id = l_cur_instance_rec.last_vld_organization_id;
14998:
14999: SELECT maint_organization_id
15000: INTO l_latest_maint_org_id
14997: WHERE organization_id = l_cur_instance_rec.last_vld_organization_id;
14998:
14999: SELECT maint_organization_id
15000: INTO l_latest_maint_org_id
15001: FROM mtl_parameters
15002: WHERE organization_id = l_get_instance_rec.vld_organization_id;
15003: l_ctr:=1;
15004: csi_gen_utility_pvt.put_line('There is a change in vld organization...');
15005: csi_gen_utility_pvt.put_line('Value of current maint org is :'||l_curr_maint_org_id);
29839: FROM bom_small_expl_temp bet
29840: ,bom_bill_of_materials bom
29841: ,mtl_system_items msi
29842: ,mtl_system_items msip
29843: ,mtl_parameters mp
29844: WHERE bet.group_id = p_group_id
29845: AND bet.plan_level > 0 -- Ignore Top Most
29846: AND bet.component_item_id = msi.inventory_item_id
29847: AND bet.organization_id = msi.organization_id
29921: -- Get the Master Organization ID
29922: BEGIN
29923: select master_organization_id
29924: into l_master_organization_id
29925: from MTL_PARAMETERS
29926: where organization_id = p_source_instance_rec.VLD_ORGANIZATION_ID;
29927: EXCEPTION
29928: when others then
29929: csi_gen_utility_pvt.put_line('Unable to get the Master organization ID for '