APPS.EDW_ITEMS_PKG SQL Statements

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

Line: 28

  select instance_code
  from edw_local_instance;

Line: 32

  select category_id
  from mtl_categories_kfv
  where concatenated_segments = p_item_category;

Line: 96

  select instance_code
  from edw_local_instance;

Line: 151

  select instance_code
  from edw_local_instance;

Line: 189

  SELECT instance_code
  FROM edw_local_instance;

Line: 225

         SELECT TO_NUMBER(MC.SEGMENT1) INTEREST_TYPE_ID,
                TO_NUMBER(MC.SEGMENT2) PRIMARY_INTEREST_CODE_ID,
                TO_NUMBER(MC.SEGMENT3) SECONDARY_INTEREST_CODE_ID
           FROM MTL_ITEM_CATEGORIES MIC,
                MTL_CATEGORIES_B     MC,
                FND_ID_FLEX_STRUCTURES FIFS
          WHERE FIFS.ID_FLEX_CODE = 'MCAT'
            AND FIFS.APPLICATION_ID = 401
            AND FIFS.ID_FLEX_STRUCTURE_CODE = 'SALES_CATEGORIES'
            AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM
            AND MIC.CATEGORY_SET_ID = 5
            AND MIC.CATEGORY_ID = MC.CATEGORY_ID
            AND MIC.INVENTORY_ITEM_ID = p_item_id
            AND MIC.ORGANIZATION_ID = p_organization_id ;

Line: 316

SELECT organization_id, master_organization_id
FROM mtl_parameters;