APPS.INV_ITEM_GRP dependencies on MTL_PARAMETERS

Line 440: , MTL_PARAMETERS MP

436: , MSI.STYLE_ITEM_FLAG
437: , MSI.STYLE_ITEM_ID
438: FROM
439: MTL_SYSTEM_ITEMS_VL MSI
440: , MTL_PARAMETERS MP
441: WHERE
442: MSI.INVENTORY_ITEM_ID = p_Item_ID
443: AND MSI.ORGANIZATION_ID = p_Org_ID
444: AND MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID;

Line 1244: from MTL_PARAMETERS

1240: -----------------------------------------------------
1241:
1242: /*
1243: select organization_id
1244: from MTL_PARAMETERS
1245: where organization_code = p_Item_rec.ORGANIZATION_code;
1246: */
1247:
1248: IF ( p_Item_rec.ORGANIZATION_ID = g_MISS_NUM

Line 1324: MTL_PARAMETERS MP

1320: , l_inventory_item_id
1321: , l_organization_id
1322: FROM
1323: MTL_SYSTEM_ITEMS_INTERFACE MSII,
1324: MTL_PARAMETERS MP
1325: WHERE set_process_id = l_set_process_id
1326: AND MP.MASTER_ORGANIZATION_ID = MP.ORGANIZATION_ID
1327: AND MP.ORGANIZATION_ID = MSII.ORGANIZATION_ID;
1328:

Line 4894: FROM mtl_parameters

4890: IF UPPER(p_Revision_rec.TRANSACTION_TYPE) IN ('CREATE','UPDATE','SYNC') THEN
4891:
4892: SELECT starting_revision
4893: INTO l_default_revision
4894: FROM mtl_parameters
4895: WHERE organization_id = p_Revision_rec.ORGANIZATION_ID;
4896:
4897: l_item_number := p_Revision_rec.ITEM_NUMBER;
4898: