APPS.INV_VALUE_TO_ID SQL Statements

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

Line: 21

    FND_API.g_attr_tbl.DELETE;

Line: 225

    SELECT  ORGANIZATION_ID
    INTO    l_id
    FROM    ORG_ORGANIZATION_DEFINITIONS
    WHERE   ORGANIZATION_CODE = p_organization;

Line: 275

    SELECT  ORGANIZATION_ID
    INTO    l_id
    FROM    ORG_ORGANIZATION_DEFINITIONS
    WHERE   ORGANIZATION_CODE = p_to_organization;

Line: 328

   SELECT gsb.chart_of_accounts_id INTO	l_chart
     FROM GL_SETS_OF_BOOKS gsb
     WHERE gsb.set_of_books_id=
     (SELECT to_number(hoi.org_information1)
      FROM HR_ORGANIZATION_INFORMATION hoi
      WHERE hoi.organization_id = p_organization_id
      AND hoi.org_information_context = 'Accounting Information'
      AND ROWNUM < 2);

Line: 513

    SELECT  INVENTORY_LOCATION_ID
    INTO    l_id
    FROM    MTL_ITEM_LOCATIONS_KFV
    WHERE   ORGANIZATION_ID = p_organization_id
      AND   CONCATENATED_SEGMENTS = p_from_locator;

Line: 567

    SELECT  INVENTORY_ITEM_ID
    INTO    l_id
    FROM    MTL_SYSTEM_ITEMS_KFV
    WHERE   CONCATENATED_SEGMENTS = p_inventory_item
      AND   ORGANIZATION_ID = p_organization_id;

Line: 926

    SELECT  INVENTORY_LOCATION_ID
    INTO    l_id
    FROM    MTL_ITEM_LOCATIONS_KFV
    WHERE   ORGANIZATION_ID = p_organization_id
      AND   CONCATENATED_SEGMENTS = p_to_locator;