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.JA_CN_SI_BANK_DET_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 267: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

263: (v.summary_flag = 'N' AND h.range_attribute = 'C'))
264: )ffv where ffv.FLEX_VALUE_SET_ID =
265: (SELECT fifsv.FLEX_VALUE_SET_ID
266: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
267: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
268: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
269: AND FSAV.APPLICATION_ID = 101
270: AND FSAV.ID_FLEX_CODE = 'GL#'
271: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID

Line 334: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

330: from fnd_flex_values_vl ffv
331: where ffv.FLEX_VALUE_SET_ID =
332: (SELECT fifsv.FLEX_VALUE_SET_ID
333: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
334: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
335: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
336: AND FSAV.APPLICATION_ID = 101
337: AND FSAV.ID_FLEX_CODE = 'GL#'
338: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID

Line 424: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

420: --get valueset_id
421: SELECT fifsv.FLEX_VALUE_SET_ID
422: into l_flex_valueset_id
423: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
424: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
425: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
426: AND FSAV.APPLICATION_ID = 101
427: AND FSAV.ID_FLEX_CODE = 'GL#'
428: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID

Line 905: FROM FND_ID_FLEX_SEGMENTS_VL fifsv, FND_SEGMENT_ATTRIBUTE_VALUES FSAV

901:
902: --get valueset id of the coa
903: SELECT fifsv.FLEX_VALUE_SET_ID
904: into l_valueset_id
905: FROM FND_ID_FLEX_SEGMENTS_VL fifsv, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
906: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
907: AND FSAV.APPLICATION_ID = 101
908: AND FSAV.ID_FLEX_CODE = 'GL#'
909: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID

Line 1078: FROM FND_ID_FLEX_SEGMENTS_VL fifsv, FND_SEGMENT_ATTRIBUTE_VALUES FSAV

1074:
1075: --get valueset id of the coa
1076: SELECT fifsv.FLEX_VALUE_SET_ID
1077: into l_valueset_id
1078: FROM FND_ID_FLEX_SEGMENTS_VL fifsv, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1079: WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
1080: AND FSAV.APPLICATION_ID = 101
1081: AND FSAV.ID_FLEX_CODE = 'GL#'
1082: AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID