APPS.INV_ITEM_GRP dependencies on MTL_PARAMETERS

Line 437: , MTL_PARAMETERS MP

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

Line 809: from MTL_PARAMETERS

805: -----------------------------------------------------
806:
807: /*
808: select organization_id
809: from MTL_PARAMETERS
810: where organization_code = p_Item_rec.ORGANIZATION_code;
811: */
812:
813: IF ( p_Item_rec.ORGANIZATION_ID = g_MISS_NUM

Line 4280: FROM mtl_parameters

4276: IF UPPER(p_Revision_rec.TRANSACTION_TYPE) IN ('CREATE','UPDATE','SYNC') THEN
4277:
4278: SELECT starting_revision
4279: INTO l_default_revision
4280: FROM mtl_parameters
4281: WHERE organization_id = p_Revision_rec.ORGANIZATION_ID;
4282:
4283: l_item_number := p_Revision_rec.ITEM_NUMBER;
4284: