APPS.INV_INVARPAR_XMLP_PKG SQL Statements

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

Line: 27

      SELECT
        MEANING
      INTO P_REJ_OPT_TITLE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = NVL(P_INCLUDE_REJ_ITEMS
         ,1);

Line: 101

      SELECT
        PHYSICAL_INVENTORY_NAME
      INTO NAME
      FROM
        MTL_PHYSICAL_INVENTORIES
      WHERE ORGANIZATION_ID = P_ORG_ID
        AND PHYSICAL_INVENTORY_ID = P_PHYS_INV_ID;

Line: 136

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = COST_GROUP_ID;

Line: 155

        SELECT
          LICENSE_PLATE_NUMBER
        INTO M_OUTERMOST_LPN
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = OUTERMOST_LPN_ID;

Line: 174

        SELECT
          LICENSE_PLATE_NUMBER
        INTO M_PARENT_LPN
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = PARENT_LPN_ID;

Line: 193

        SELECT
          FULL_NAME
        INTO V_EMP_NAME
        FROM
          MTL_EMPLOYEES_VIEW
        WHERE ORGANIZATION_ID = P_ORG_ID
          AND EMPLOYEE_ID = EMP_ID;

Line: 213

        SELECT
          FULL_NAME
        INTO V_EMP_NAME
        FROM
          MTL_EMPLOYEES_VIEW
        WHERE ORGANIZATION_ID = P_ORG_ID
          AND EMPLOYEE_ID = EMP_ID;