APPS.INV_INVCCIER_XMLP_PKG SQL Statements

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

Line: 21

      SELECT
        ORGANIZATION_NAME
      INTO P_ORG_NAME
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 36

                   ,'Failed in before report trigger, item select. ')*/NULL;

Line: 44

                   ,'Failed in before report trigger, locator select. ')*/NULL;

Line: 53

        SELECT
          CYCLE_COUNT_HEADER_NAME
        INTO P_CYCLE_COUNT_HEADER_NAME
        FROM
          MTL_CYCLE_COUNT_HEADERS
        WHERE CYCLE_COUNT_HEADER_ID = P_CYCLE_COUNT_HEADER_ID;

Line: 67

        SELECT
          MEANING
        INTO P_ACTION
        FROM
          MFG_LOOKUPS
        WHERE LOOKUP_TYPE = 'MTL_CCEOI_ACTION_CODE'
          AND LOOKUP_CODE = P_ACTION_CODE;