APPS.EGO_ITEM_COMPARE_PKG SQL Statements

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

Line: 82

        SELECT meaning
        FROM   fnd_lookup_values_vl
      WHERE  lookup_type = 'ITEM_TYPE'
      AND    lookup_code = p_lookup_code;

Line: 113

        SELECT meaning
        FROM   fnd_lookup_values
      WHERE  language = userenv('LANG')
       AND    lookup_type = 'INV_ITEM_APPROVAL_STATUS'
       AND    lookup_code = p_approval_status_val;

Line: 145

        SELECT meaning
        FROM   fnd_lookup_values_vl
      WHERE  lookup_type = 'MTL_CONVERSION_TYPE'
      AND    lookup_code = p_conversion_val;

Line: 175

        SELECT description
        FROM   mtl_units_of_measure_tl
      WHERE  language = userenv('LANG')
      AND    uom_code = p_uom_code;

Line: 205

    SELECT catalog_group
    FROM ego_catalog_groups_v
    WHERE catalog_group_id = p_catalog_group_id;

Line: 234

        SELECT name  lifecycle_name
        FROM   pa_ego_lifecycles_v
--        FROM   pa_proj_elements
        WHERE  proj_element_id = p_lifecycle_id;

Line: 265

        SELECT name  lifecycle_phase_name
        FROM   pa_ego_phases_v
--        FROM   pa_proj_elements
        WHERE  proj_element_id = p_lifecycle_phase_id;

Line: 296

        SELECT meaning
        FROM   fnd_lookup_values
        WHERE  language = userenv('LANG')
        AND    lookup_type = 'EGO_YES_NO'
        AND    lookup_code = p_style_flag;

Line: 328

        SELECT CONCATENATED_SEGMENTS
        FROM   MTL_SYSTEM_ITEMS_VL
        WHERE  inventory_item_id = p_style_item_id
        AND organization_id = p_organization_id;

Line: 352

      SELECT DISPLAY_NAME
      FROM EGO_VALUE_SET_VALUES_V
      WHERE ENABLED_CODE = 'Y'
      AND ((START_DATE IS NULL) OR (START_DATE IS NOT NULL AND START_DATE <= SYSDATE))
      AND ((END_DATE IS NULL) OR (END_DATE IS NOT NULL AND END_DATE >= SYSDATE))
      AND INTERNAL_NAME =  p_trade_item_desc;

Line: 422

         l_dyn_sql := l_dyn_sql || ' SELECT '|| l_db_column;

Line: 557

            SELECT 'HZ_PARTY:'||TO_CHAR(PERSON_ID)
              INTO l_user_party_id
              FROM EGO_PEOPLE_V
             WHERE USER_NAME = FND_GLOBAL.USER_NAME;

Line: 596

        SELECT  defaulting
        INTO    l_ag_defaulting
        FROM    ego_attr_group_dl
        WHERE   attr_group_id =
               (SELECT  attr_group_id
                FROM    ego_attr_groups_v
                WHERE   application_id  = p_appl_id
                    AND attr_group_type = p_attr_grp_type
                    AND attr_group_name = p_attr_grp_name
                )
            AND data_level_id =
               (SELECT  data_level_id
                FROM    ego_data_level_b
                WHERE   data_level_name = p_data_level_name
                    AND attr_group_type = p_attr_grp_type
                    AND application_id  = p_appl_id
                );

Line: 618

          SELECT  COALESCE(style_item_id, inventory_item_id) item_id
          INTO    l_item_to_query
          FROM    mtl_system_items_b
          WHERE   inventory_item_id = p_inventory_item_id AND
                  organization_ID   = p_organization_id;