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 365: MTL_PARAMETERS mp

361: l_org_array
362: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
363: MTL_ITEM_CATALOG_GROUPS_VL micg,
364: ENG_CHANGE_ORDER_TYPES_VL eng_types,
365: MTL_PARAMETERS mp
366: WHERE msii.set_process_id=P_BATCH_ID
367: AND PROCESS_FLAG = l_process_flag
368: AND msii.ITEM_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID
369: -- AND micg.NEW_ITEM_REQ_CHANGE_TYPE_ID = eng_types.change_order_type_id

Line 402: MTL_PARAMETERS mp,

398: l_change_type_array,
399: l_org_array
400: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
401: ENG_CHANGE_ORDER_TYPES_VL eng_types,
402: MTL_PARAMETERS mp,
403: ego_item_cat_denorm_hier heir,
404: mtl_item_catalog_groups_b micgb
405: WHERE msii.set_process_id = P_BATCH_ID
406: AND PROCESS_FLAG = l_process_flag

Line 433: MTL_PARAMETERS mp

429: l_change_type_array,
430: l_org_array
431: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
432: -- ENG_CHANGE_ORDER_TYPES eng_types,
433: MTL_PARAMETERS mp
434: WHERE msii.set_process_id=P_BATCH_ID
435: AND PROCESS_FLAG = l_process_flag
436: AND mp.organization_id = msii.organization_id
437: order by organization_id;

Line 456: from mtl_parameters mp

452: if l_prev_org_id IS NULL OR l_org_id <> l_prev_org_id
453: then
454: select organization_code
455: into l_org_code
456: from mtl_parameters mp
457: where mp.organization_id = l_org_id;
458: l_prev_org_id := l_org_id;
459: end if;
460:

Line 536: from mtl_parameters mp

532: if l_prev_org_id is null OR l_org_id <> l_prev_org_id
533: then
534: select organization_code
535: into l_org_code
536: from mtl_parameters mp
537: where mp.organization_id = l_org_id;
538: l_prev_org_id := l_org_id;
539: end if;
540: l_change_ids_array := NIR_CHANGE_TABLE();