APPS.CSP_ASL_PUB SQL Statements

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

Line: 50

  SELECT ORGANIZATION_ID
  FROM   MTL_PARAMETERS
  WHERE  ORGANIZATION_CODE=inv_org_code;

Line: 55

  SELECT ORGANIZATION_ID
  FROM   HR_ALL_ORGANIZATION_UNITS
  WHERE  NAME = inv_org_name;

Line: 60

  select CONCATENATED_SEGMENT_DELIMITER
  from FND_ID_FLEX_STRUCTURES_VL
  where APPLICATION_ID=401
  and ID_FLEX_CODE='MSTK';

Line: 66

  select count(*)
  from FND_ID_FLEX_SEGMENTS_VL
  where application_id= 401
  and ID_FLEX_CODE='MSTK'
  and ENABLED_FLAG='Y';

Line: 196

       l_sql_string := 'SELECT INVENTORY_ITEM_ID from mtl_system_items_b_kfv where CONCATENATED_SEGMENTS =' || '''' || conc_segments || '''';

Line: 205

            SELECT CSP_USAGE_HEADERS_S1.NEXTVAL INTO l_header_id FROM DUAL;

Line: 206

            INSERT INTO CSP_USAGE_HEADERS  (USAGE_HEADER_ID,INVENTORY_ITEM_ID,ORGANIZATION_ID,RECOMMENDED_MIN_QUANTITY,
                                        RECOMMENDED_MAX_QUANTITY,EXTERNAL_DATA,PROCESS_STATUS,CREATED_BY,
                                        CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,HEADER_DATA_TYPE)
                              VALUES   (l_header_id,l_item_id,l_organization_id, p_recommended_min,p_recommended_max,
                                        'Y','M',G_USER_ID, SYSDATE,  G_USER_ID, SYSDATE, G_LOGIN_ID,4);

Line: 213

            INSERT INTO CSP_USAGE_HEADERS  (USAGE_HEADER_ID,INVENTORY_ITEM_ID,ORGANIZATION_ID,RECOMMENDED_MIN_QUANTITY,
                                        RECOMMENDED_MAX_QUANTITY,EXTERNAL_DATA,PROCESS_STATUS,CREATED_BY,
                                        CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,HEADER_DATA_TYPE,SECONDARY_INVENTORY)
                              VALUES   (l_header_id,l_item_id,l_organization_id, p_recommended_min,p_recommended_max,
                                        'Y','M',G_USER_ID, SYSDATE,  G_USER_ID, SYSDATE, G_LOGIN_ID,1,p_subinventory_code);