APPS.MTL_PENDING_STATUS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

        SELECT control_level
        FROM   MTL_ITEM_ATTRIBUTES A
        WHERE  A.ATTRIBUTE_NAME =
                'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

Line: 23

        SELECT MASTER_ORGANIZATION_ID
        FROM   MTL_PARAMETERS P
        WHERE  P.ORGANIZATION_ID = PASS_ORG;

Line: 58

  SELECT   organization_code, organization_name
    INTO   X_CUR_ORG_CODE, X_CUR_ORG_NAME
    FROM   ORG_ORGANIZATION_DEFINITIONS
    WHERE  ORGANIZATION_ID = SEL_ORG;