APPS.EAM_EAMMIPCK_XMLP_PKG SQL Statements

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

Line: 24

      SELECT
        MEANING
      INTO P_ORDER_BY_DISP
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'EAM_MATERIAL_ISSUE_SORT_BY'
        AND LOOKUP_CODE = P_ORDER_BY_USED;

Line: 52

        SELECT
          CONCATENATED_SEGMENTS
        INTO P_SOURCE_LOCATOR_NAME
        FROM
          MTL_ITEM_LOCATIONS_KFV
        WHERE INVENTORY_LOCATION_ID = P_SOURCE_LOCATOR
          AND ORGANIZATION_ID = P_ORG_ID
          AND SUBINVENTORY_CODE = P_SOURCE_SUBINVENTORY;

Line: 70

        SELECT
          USER_NAME
        INTO P_REQUESTER_NAME
        FROM
          FND_USER
        WHERE USER_ID = P_REQUESTER;

Line: 85

        SELECT
          WIP_ENTITY_NAME
        INTO P_WORK_ORDER_NAME
        FROM
          WIP_ENTITIES
        WHERE WIP_ENTITY_ID = P_WORK_ORDER
          AND ORGANIZATION_ID = P_ORG_ID;

Line: 100

        SELECT
          CONCATENATED_SEGMENTS
        INTO P_MATERIAL_NAME
        FROM
          MTL_SYSTEM_ITEMS_KFV
        WHERE INVENTORY_ITEM_ID = P_MATERIAL
          AND ORGANIZATION_ID = P_ORG_ID;

Line: 117

    SELECT
      ORG.ORGANIZATION_CODE
    INTO P_ORG_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS ORG
    WHERE ORG.ORGANIZATION_ID = P_ORG_ID;