APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on MTL_PARAMETERS

Line 104: FROM mtl_parameters org_param

100:
101: CURSOR c_change_id (p_change_notice IN VARCHAR2, p_org_code IN VARCHAR2)
102: IS
103: SELECT CHANGE_ID
104: FROM mtl_parameters org_param
105: , eng_engineering_changes eng_change
106: WHERE eng_change.change_notice = p_change_notice
107: AND eng_change.organization_id = org_param.organization_id
108: AND org_param.organization_code = p_org_code;

Line 348: MTL_PARAMETERS mp

344: l_org_array
345: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
346: MTL_ITEM_CATALOG_GROUPS_VL micg,
347: ENG_CHANGE_ORDER_TYPES_VL eng_types,
348: MTL_PARAMETERS mp
349: WHERE msii.set_process_id=P_BATCH_ID
350: AND PROCESS_FLAG = l_process_flag
351: AND msii.ITEM_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID
352: -- AND micg.NEW_ITEM_REQ_CHANGE_TYPE_ID = eng_types.change_order_type_id

Line 384: MTL_PARAMETERS mp,

380: l_change_type_array,
381: l_org_array
382: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
383: ENG_CHANGE_ORDER_TYPES_VL eng_types,
384: MTL_PARAMETERS mp,
385: ego_item_cat_denorm_hier heir,
386: mtl_item_catalog_groups_b micgb
387: WHERE msii.set_process_id = P_BATCH_ID
388: AND PROCESS_FLAG = l_process_flag

Line 408: from mtl_parameters mp

404: if l_prev_org_id IS NULL OR l_org_id <> l_prev_org_id
405: then
406: select organization_code
407: into l_org_code
408: from mtl_parameters mp
409: where mp.organization_id = l_org_id;
410: l_prev_org_id := l_org_id;
411: end if;
412:

Line 484: from mtl_parameters mp

480: if l_prev_org_id is null OR l_org_id <> l_prev_org_id
481: then
482: select organization_code
483: into l_org_code
484: from mtl_parameters mp
485: where mp.organization_id = l_org_id;
486: l_prev_org_id := l_org_id;
487: end if;
488: l_change_ids_array := NIR_CHANGE_TABLE();