eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_FLEX_UTIL dependencies on FND_ID_FLEX_SEGMENTS

Line 7: FROM fnd_id_flex_segments

3:
4: CURSOR flex_segments_csr(p_chart_of_accounts_id NUMBER)
5: IS
6: SELECT segment_num, application_column_name
7: FROM fnd_id_flex_segments
8: WHERE application_id = 101
9: AND id_flex_code = 'GL#'
10: AND enabled_flag = 'Y'
11: AND id_flex_num = p_chart_of_accounts_id

Line 19: FROM fnd_id_flex_segments_vl

15: p_segmentinfo OUT NOCOPY t_segmentinfo
16: ) RETURN BOOLEAN IS
17: CURSOR c_getsegmentnum(c_chartOfAccountsID NUMBER) IS
18: SELECT segment_num
19: FROM fnd_id_flex_segments_vl
20: WHERE application_id = 101
21: AND id_flex_code = 'GL#'
22: AND enabled_flag = 'Y'
23: AND id_flex_num = c_chartOfAccountsID

Line 234: FROM fnd_id_flex_segments

230: CURSOR flex_segment_name_csr(p_chart_of_accounts_id NUMBER
231: ,p_segment_number NUMBER)
232: IS
233: SELECT application_column_name
234: FROM fnd_id_flex_segments
235: WHERE application_id = 101
236: AND id_flex_code = 'GL#'
237: AND enabled_flag = 'Y'
238: AND id_flex_num = p_chart_of_accounts_id

Line 370: FND_ID_FLEX_SEGMENTS_VL SG,

366: p_parent_col_name
367: FROM FND_ID_FLEXS K,
368: FND_APPLICATION_VL A,
369: FND_ID_FLEX_STRUCTURES_VL S,
370: FND_ID_FLEX_SEGMENTS_VL SG,
371: FND_FLEX_VALUE_SETS V,
372: FND_ID_FLEX_SEGMENTS_VL SG2,
373: FND_FLEX_VALIDATION_TABLES T
374: WHERE K.APPLICATION_ID = A.APPLICATION_ID

Line 372: FND_ID_FLEX_SEGMENTS_VL SG2,

368: FND_APPLICATION_VL A,
369: FND_ID_FLEX_STRUCTURES_VL S,
370: FND_ID_FLEX_SEGMENTS_VL SG,
371: FND_FLEX_VALUE_SETS V,
372: FND_ID_FLEX_SEGMENTS_VL SG2,
373: FND_FLEX_VALIDATION_TABLES T
374: WHERE K.APPLICATION_ID = A.APPLICATION_ID
375: AND K.APPLICATION_ID = S.APPLICATION_ID
376: AND K.ID_FLEX_CODE = S.ID_FLEX_CODE

Line 389: FROM FND_ID_FLEX_SEGMENTS SG3

385: AND K.ID_FLEX_CODE = NVL(SG2.ID_FLEX_CODE, K.ID_FLEX_CODE)
386: AND S.ID_FLEX_NUM = NVL(SG2.ID_FLEX_NUM, S.ID_FLEX_NUM)
387: AND NVL(SG2.ENABLED_FLAG, 'Y') = 'Y'
388: AND NVL(SG2.SEGMENT_NUM,0) = (SELECT NVL(MAX(SG3.SEGMENT_NUM),0)
389: FROM FND_ID_FLEX_SEGMENTS SG3
390: WHERE SG3.APPLICATION_ID = K.APPLICATION_ID
391: AND SG3.ID_FLEX_CODE = K.ID_FLEX_CODE
392: AND SG3.ID_FLEX_NUM = S.ID_FLEX_NUM
393: AND SG3.FLEX_VALUE_SET_ID = V.PARENT_FLEX_VALUE_SET_ID