APPS.XLA_FLEX_UTIL SQL Statements

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

Line: 6

      SELECT segment_num, application_column_name
      FROM fnd_id_flex_segments
      WHERE application_id = 101
      AND   id_flex_code   = 'GL#'
      AND   enabled_flag   = 'Y'
      AND   id_flex_num    = p_chart_of_accounts_id
      ORDER BY segment_num;

Line: 18

      SELECT  segment_num
	FROM fnd_id_flex_segments_vl
	WHERE application_id = 101
	AND   id_flex_code   = 'GL#'
	AND   enabled_flag   = 'Y'
	AND   id_flex_num    =  c_chartOfAccountsID
	ORDER BY segment_num;

Line: 233

      SELECT application_column_name
      FROM fnd_id_flex_segments
      WHERE application_id = 101
      AND   id_flex_code   = 'GL#'
      AND   enabled_flag   = 'Y'
      AND   id_flex_num    = p_chart_of_accounts_id
      AND   segment_num = p_segment_number;

Line: 292

  SELECT FLEX_VALUE_SET_ID
  FROM FND_FLEX_VALUE_SETS
  WHERE FLEX_VALUE_SET_NAME = p_ValueSetName;

Line: 361

    SELECT DECODE(V.PARENT_FLEX_VALUE_SET_ID,
		  NULL,SG.SEGMENT_Num , SG2.SEGMENT_num)   parent_seg_num,
           DECODE(V.PARENT_FLEX_VALUE_SET_ID,
		  NULL,NULL , SG2.application_column_name) parent_app_col_name
      INTO p_parent_segment_num,
           p_parent_col_name
    FROM   FND_ID_FLEXS K,
           FND_APPLICATION_VL A,
           FND_ID_FLEX_STRUCTURES_VL S,
           FND_ID_FLEX_SEGMENTS_VL SG,
           FND_FLEX_VALUE_SETS V,
           FND_ID_FLEX_SEGMENTS_VL SG2,
           FND_FLEX_VALIDATION_TABLES T
   WHERE K.APPLICATION_ID = A.APPLICATION_ID
   AND   K.APPLICATION_ID = S.APPLICATION_ID
   AND   K.ID_FLEX_CODE = S.ID_FLEX_CODE
   AND   S.ENABLED_FLAG = 'Y'
   AND   K.APPLICATION_ID = SG.APPLICATION_ID
   AND   K.ID_FLEX_CODE = SG.ID_FLEX_CODE
   AND   S.ID_FLEX_NUM = SG.ID_FLEX_NUM
   AND   SG.ENABLED_FLAG = 'Y'
   AND   SG.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
   AND   V.PARENT_FLEX_VALUE_SET_ID = SG2.FLEX_VALUE_SET_ID(+)
   AND   K.APPLICATION_ID = NVL(SG2.APPLICATION_ID, K.APPLICATION_ID)
   AND   K.ID_FLEX_CODE = NVL(SG2.ID_FLEX_CODE, K.ID_FLEX_CODE)
   AND   S.ID_FLEX_NUM = NVL(SG2.ID_FLEX_NUM, S.ID_FLEX_NUM)
   AND   NVL(SG2.ENABLED_FLAG, 'Y') = 'Y'
   AND   NVL(SG2.SEGMENT_NUM,0) = (SELECT NVL(MAX(SG3.SEGMENT_NUM),0)
				   FROM FND_ID_FLEX_SEGMENTS SG3
				   WHERE SG3.APPLICATION_ID = K.APPLICATION_ID
				   AND SG3.ID_FLEX_CODE = K.ID_FLEX_CODE
				   AND SG3.ID_FLEX_NUM = S.ID_FLEX_NUM
				   AND SG3.FLEX_VALUE_SET_ID = V.PARENT_FLEX_VALUE_SET_ID
				   AND SG3.SEGMENT_NUM < SG.SEGMENT_NUM
				   AND SG3.ENABLED_FLAG = 'Y')
   AND V.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)
   AND k.application_id    = p_application_id
   AND k.id_flex_code      = p_flex_code
   AND s.id_flex_num       = p_structure_id
   AND sg.segment_num      = p_child_segment_num;