The following lines contain the word 'select', 'insert', 'update' or 'delete':
,'Failed Flexsql MCAT select in before rpt trig')*/NULL;
,'Failed Flexsql Item Select in before rpt trig')*/NULL;
RETURN ('/* Do not select mic or mc */');
SELECT
CATEGORY_SET_NAME
INTO NAME
FROM
MTL_CATEGORY_SETS
WHERE CATEGORY_SET_ID = SET_ID;
SELECT
CONTROL_LEVEL
INTO T_STATUS
FROM
MTL_ITEM_ATTRIBUTES
WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
SELECT
MASTER_ORGANIZATION_ID
INTO T_MORG_ID
FROM
MTL_PARAMETERS P
WHERE P.ORGANIZATION_ID = P_ORG_ID;