APPS.INVNIRIS dependencies on MTL_PARAMETERS

Line 44: MTL_PARAMETERS mp

40: mp.MASTER_ORGANIZATION_ID,
41: msii.TRANSACTION_TYPE
42: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
43: --MTL_ITEM_CATALOG_GROUPS_B micb,
44: MTL_PARAMETERS mp
45: WHERE ( (msii.organization_id + 0 = org_id) OR (all_Org = 1) )
46: AND msii.process_flag = cp_process_flag
47: AND msii.set_process_id = xset_id
48: --AND msii.ITEM_CATALOG_GROUP_ID = micb.ITEM_CATALOG_GROUP_ID

Line 116: FROM mtl_parameters mp

112: INTO l_item_approval_status
113: FROM mtl_system_items_b msi
114: WHERE msi.inventory_item_id = cur.inventory_item_id
115: AND msi.organization_id = (SELECT mp.master_organization_id
116: FROM mtl_parameters mp
117: WHERE mp.organization_id = cur.organization_id);
118: EXCEPTION
119: WHEN OTHERS THEN
120: l_item_approval_status := 'N';

Line 601: from mtl_parameters m

597: AND i.set_process_id = xset_id
598: AND ((i.organization_id = org_id) or (all_org = 1))
599: AND i.transaction_type = 'CREATE'
600: AND i.revision <> (select m.starting_revision
601: from mtl_parameters m
602: where m.organization_id = i.organization_id);
603: END IF;
604:
605: RETURN (status);