APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on MTL_PARAMETERS

Line 2102: mtl_parameters mp

2098: l_Count
2099: FROM
2100: bom_bill_of_materials bb,
2101: mtl_system_items_kfv it,
2102: mtl_parameters mp
2103: WHERE
2104: bb.assembly_item_id = it.inventory_item_id AND
2105: it.organization_id = bb.organization_id AND
2106: bb.organization_id = mp.organization_id AND

Line 2147: mtl_parameters mp

2143:
2144: SELECT bill_sequence_id, source_bill_sequence_id INTO l_bill_sequence_id, l_src_bill_sequence_id
2145: FROM BOM_BILL_OF_MATERIALS bb,
2146: mtl_system_items_kfv it,
2147: mtl_parameters mp
2148: WHERE bb.assembly_item_id = it.inventory_item_id
2149: AND it.organization_id = bb.organization_id
2150: AND bb.organization_id = mp.organization_id
2151: AND mp.organization_code = p_Organization_Code

Line 2195: mtl_parameters mp

2191: SELECT COUNT(1) INTO l_Count
2192: FROM
2193: eng_revised_items eri,
2194: mtl_system_items_kfv msi,
2195: mtl_parameters mp
2196: WHERE
2197: eri.revised_item_id = msi.inventory_item_id AND
2198: msi.organization_id = eri.organization_id AND
2199: eri.organization_id = mp.organization_id AND

Line 2232: FROM mtl_parameters

2228:
2229: BEGIN
2230:
2231: SELECT master_organization_id INTO l_master_org
2232: FROM mtl_parameters
2233: WHERE organization_id= p_organization_id;
2234:
2235: IF(l_master_org <> p_organization_id) THEN
2236: RETURN FND_API.g_true;

Line 2306: l_context_org_code mtl_parameters.organization_code%TYPE;

2302: l_revised_item inv_ebi_revised_item_obj;
2303: l_revised_item1 inv_ebi_revised_item_obj;
2304: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2305: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2306: l_context_org_code mtl_parameters.organization_code%TYPE;
2307: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2308: l_component_item inv_ebi_rev_comp_obj;
2309: l_component_item1 inv_ebi_rev_comp_obj;
2310: l_eco_obj inv_ebi_eco_obj;

Line 2323: l_reference_org_code mtl_parameters.organization_code%TYPE;

2319: l_config_impl_scope VARCHAR2(30) := 'ALL';
2320: l_return_status VARCHAR2(10);
2321: l_msg_Count NUMBER;
2322: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
2323: l_reference_org_code mtl_parameters.organization_code%TYPE;
2324: l_as_of_date DATE;
2325: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
2326: l_output_status inv_ebi_output_status;
2327:

Line 2366: mtl_parameters

2362: organization_code
2363: INTO
2364: l_reference_org_code
2365: FROM
2366: mtl_parameters
2367: WHERE
2368: organization_id = l_from_org_id;
2369: END IF;
2370:

Line 5141: ,mtl_parameters mp

5137: ,eec.cancellation_date
5138: ,ecot.type_name
5139: FROM
5140: eng_engineering_changes eec
5141: ,mtl_parameters mp
5142: ,eng_change_statuses_vl ecsv
5143: ,eng_ecn_approval_lists eeal
5144: ,hz_parties hp
5145: ,pa_projects_all ppa

Line 6051: FROM eng_engineering_changes ec, mtl_parameters mp

6047: IF p_eco_tbl IS NOT NULL AND p_eco_tbl.COUNT>0 THEN
6048: FOR i in p_eco_tbl.FIRST..p_eco_tbl.LAST LOOP
6049: l_org_code := NULL;
6050: SELECT mp.organization_code INTO l_org_code
6051: FROM eng_engineering_changes ec, mtl_parameters mp
6052: WHERE ec.change_id = p_eco_tbl(i).change_id
6053: AND ec.organization_id = mp.organization_id;
6054: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT>0 THEN
6055: FOR j in l_org_tbl.FIRST..l_org_tbl.LAST LOOP

Line 6170: FROM mtl_parameters

6166: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
6167: BEGIN
6168: FND_MSG_PUB.initialize();
6169: SELECT COUNT(1) into l_entity_exist
6170: FROM mtl_parameters
6171: WHERE organization_code = l_org_tbl(i);
6172: IF l_entity_exist>0 THEN
6173: l_entity_count := l_entity_count +1;
6174: l_valid_org_tbl.EXTEND();