APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on MTL_PARAMETERS

Line 1525: mtl_parameters mp

1521: l_Count
1522: FROM
1523: bom_bill_of_materials bb,
1524: mtl_system_items_kfv it,
1525: mtl_parameters mp
1526: WHERE
1527: bb.assembly_item_id = it.inventory_item_id AND
1528: it.organization_id = bb.organization_id AND
1529: bb.organization_id = mp.organization_id AND

Line 1567: mtl_parameters mp

1563: SELECT COUNT(1) INTO l_Count
1564: FROM
1565: eng_revised_items eri,
1566: mtl_system_items_kfv msi,
1567: mtl_parameters mp
1568: WHERE
1569: eri.revised_item_id = msi.inventory_item_id AND
1570: msi.organization_id = eri.organization_id AND
1571: eri.organization_id = mp.organization_id AND

Line 1601: FROM mtl_parameters

1597:
1598: BEGIN
1599:
1600: SELECT master_organization_id INTO l_master_org
1601: FROM mtl_parameters
1602: WHERE organization_id= p_organization_id;
1603:
1604: IF(l_master_org <> p_organization_id) THEN
1605: RETURN FND_API.g_true;

Line 1673: l_context_org_code mtl_parameters.organization_code%TYPE;

1669: l_revised_item inv_ebi_revised_item_obj;
1670: l_revised_item1 inv_ebi_revised_item_obj;
1671: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1673: l_context_org_code mtl_parameters.organization_code%TYPE;
1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1675: l_component_item inv_ebi_rev_comp_obj;
1676: l_component_item1 inv_ebi_rev_comp_obj;
1677: l_eco_obj inv_ebi_eco_obj;

Line 1690: l_reference_org_code mtl_parameters.organization_code%TYPE;

1686: l_config_impl_scope VARCHAR2(30) := 'ALL';
1687: l_return_status VARCHAR2(10);
1688: l_msg_Count NUMBER;
1689: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
1690: l_reference_org_code mtl_parameters.organization_code%TYPE;
1691: l_as_of_date DATE;
1692: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
1693: l_output_status inv_ebi_output_status;
1694:

Line 1730: mtl_parameters

1726: organization_code
1727: INTO
1728: l_reference_org_code
1729: FROM
1730: mtl_parameters
1731: WHERE
1732: organization_id = l_from_org_id;
1733: END IF;
1734:

Line 4198: ,mtl_parameters mp

4194: ,eec.cancellation_date
4195: ,ecot.type_name
4196: FROM
4197: eng_engineering_changes eec
4198: ,mtl_parameters mp
4199: ,eng_change_statuses_vl ecsv
4200: ,eng_ecn_approval_lists eeal
4201: ,hz_parties hp
4202: ,pa_projects_all ppa

Line 5100: FROM eng_engineering_changes ec, mtl_parameters mp

5096: IF p_eco_tbl IS NOT NULL AND p_eco_tbl.COUNT>0 THEN
5097: FOR i in p_eco_tbl.FIRST..p_eco_tbl.LAST LOOP
5098: l_org_code := NULL;
5099: SELECT mp.organization_code INTO l_org_code
5100: FROM eng_engineering_changes ec, mtl_parameters mp
5101: WHERE ec.change_id = p_eco_tbl(i).change_id
5102: AND ec.organization_id = mp.organization_id;
5103: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT>0 THEN
5104: FOR j in l_org_tbl.FIRST..l_org_tbl.LAST LOOP

Line 5209: FROM mtl_parameters

5205: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
5206: BEGIN
5207: FND_MSG_PUB.initialize();
5208: SELECT COUNT(1) into l_entity_exist
5209: FROM mtl_parameters
5210: WHERE organization_code = l_org_tbl(i);
5211: IF l_entity_exist>0 THEN
5212: l_entity_count := l_entity_count +1;
5213: l_valid_org_tbl.EXTEND();