APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_PARAMETERS

Line 5174: ,mtl_parameters mp

5170: FROM bom_small_expl_temp bet
5171: ,bom_bill_of_materials bom
5172: ,mtl_system_items msi
5173: ,mtl_system_items msip
5174: ,mtl_parameters mp
5175: ,wip_requirement_operations wro
5176: WHERE bet.group_id = p_group_id
5177: AND bet.plan_level > 0 -- Ignore Top Most
5178: AND bet.component_item_id = msi.inventory_item_id

Line 5338: mtl_parameters mp

5334: FROM bom_small_expl_temp bet ,
5335: bom_bill_of_materials bom ,
5336: mtl_system_items msi ,
5337: mtl_system_items msip ,
5338: mtl_parameters mp
5339: WHERE bet.group_id = p_group_id
5340: AND bet.plan_level > 0 -- Ignore Top Most
5341: AND bet.component_item_id = msi.inventory_item_id
5342: AND bet.organization_id = msi.organization_id

Line 11883: from MTL_PARAMETERS mp

11879: p_org_id => l_line_tbl(l_count).org_id);
11880:
11881: select mp.master_organization_id
11882: into l_organization_id
11883: from MTL_PARAMETERS mp
11884: where mp.organization_id = l_organization_id;
11885:
11886: Exception
11887: when others then

Line 11905: from MTL_PARAMETERS mp

11901: p_org_id => l_line_tbl(l_count).org_id);
11902:
11903: select mp.master_organization_id
11904: into l_organization_id
11905: from MTL_PARAMETERS mp
11906: where mp.organization_id = l_organization_id;
11907: Exception
11908: when others then
11909: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');

Line 12118: from MTL_PARAMETERS mp

12114: p_org_id => l_line_tbl(l_count).org_id);
12115:
12116: select mp.master_organization_id
12117: into l_organization_id
12118: from MTL_PARAMETERS mp
12119: where mp.organization_id = l_organization_id;
12120: Exception
12121: when others then
12122: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '

Line 12139: from MTL_PARAMETERS mp

12135: p_org_id => l_line_tbl(l_count).org_id);
12136:
12137: select mp.master_organization_id
12138: into l_organization_id
12139: from MTL_PARAMETERS mp
12140: where mp.organization_id = l_organization_id;
12141: Exception
12142: when others then
12143: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');

Line 12330: from MTL_PARAMETERS mp

12326: p_org_id => v_rec.org_id);
12327:
12328: select mp.master_organization_id
12329: into l_organization_id
12330: from MTL_PARAMETERS mp
12331: where mp.organization_id = l_organization_id;
12332: Exception
12333: when others then
12334: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '

Line 12347: from MTL_PARAMETERS mp

12343: p_org_id => v_rec.org_id);
12344:
12345: select mp.master_organization_id
12346: into l_organization_id
12347: from MTL_PARAMETERS mp
12348: where mp.organization_id = l_organization_id;
12349: Exception
12350: when others then
12351: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');