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_GLOBAL

Line 858: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,

854: and flv.security_group_id = 0
855: and language = userenv('LANG')
856: and flv.lookup_code =
857: (substr(COMPILED_VALUE_ATTRIBUTES,
858: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,
859: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -
860: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,
861: (select FLV.MEANING
862: from FND_LOOKUP_VALUES flv

Line 859: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -

855: and language = userenv('LANG')
856: and flv.lookup_code =
857: (substr(COMPILED_VALUE_ATTRIBUTES,
858: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,
859: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -
860: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,
861: (select FLV.MEANING
862: from FND_LOOKUP_VALUES flv
863: where flv.lookup_type = 'JA_CN_DEBIT_CREDIT'

Line 860: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,

856: and flv.lookup_code =
857: (substr(COMPILED_VALUE_ATTRIBUTES,
858: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,
859: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -
860: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,
861: (select FLV.MEANING
862: from FND_LOOKUP_VALUES flv
863: where flv.lookup_type = 'JA_CN_DEBIT_CREDIT'
864: and flv.view_APPLICATION_ID = 0

Line 868: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) + 1))) balance_side,

864: and flv.view_APPLICATION_ID = 0
865: and flv.security_group_id = 0
866: and language = userenv('LANG')
867: and flv.lookup_code = (substr(COMPILED_VALUE_ATTRIBUTES,
868: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) + 1))) balance_side,
869: to_char(nvl(b.START_DATE_ACTIVE,b.creation_date),'YYYYMMDD') START_DATE_ACTIVE,to_char(b.end_date_active,'YYYYMMDD') end_date_active
870: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B
871: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
872: and T.LANGUAGE = userenv('LANG')

Line 874: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,

870: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B
871: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
872: and T.LANGUAGE = userenv('LANG')
873: and substr(COMPILED_VALUE_ATTRIBUTES,
874: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,
875: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -
876: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'I'
877: and b.FLEX_VALUE_SET_ID = c_valueset_id;
878:

Line 875: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -

871: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
872: and T.LANGUAGE = userenv('LANG')
873: and substr(COMPILED_VALUE_ATTRIBUTES,
874: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,
875: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -
876: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'I'
877: and b.FLEX_VALUE_SET_ID = c_valueset_id;
878:
879: lv_procedure_name VARCHAR2(40) := 'Add_Inner_Sheet_Account';

Line 876: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'I'

872: and T.LANGUAGE = userenv('LANG')
873: and substr(COMPILED_VALUE_ATTRIBUTES,
874: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,
875: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -
876: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'I'
877: and b.FLEX_VALUE_SET_ID = c_valueset_id;
878:
879: lv_procedure_name VARCHAR2(40) := 'Add_Inner_Sheet_Account';
880: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1026: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,

1022: and flv.security_group_id = 0
1023: and language = userenv('LANG')
1024: and flv.lookup_code =
1025: (substr(COMPILED_VALUE_ATTRIBUTES,
1026: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,
1027: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -
1028: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,
1029: (select FLV.MEANING
1030: from FND_LOOKUP_VALUES flv

Line 1027: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -

1023: and language = userenv('LANG')
1024: and flv.lookup_code =
1025: (substr(COMPILED_VALUE_ATTRIBUTES,
1026: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,
1027: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -
1028: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,
1029: (select FLV.MEANING
1030: from FND_LOOKUP_VALUES flv
1031: where flv.lookup_type = 'JA_CN_UOM'

Line 1028: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,

1024: and flv.lookup_code =
1025: (substr(COMPILED_VALUE_ATTRIBUTES,
1026: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2) + 1,
1027: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 3) - 1 -
1028: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 2)))) acc_type,
1029: (select FLV.MEANING
1030: from FND_LOOKUP_VALUES flv
1031: where flv.lookup_type = 'JA_CN_UOM'
1032: and flv.view_APPLICATION_ID = 0

Line 1037: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) + 1,

1033: and flv.security_group_id = 0
1034: and language = userenv('LANG')
1035: and flv.lookup_code =
1036: (substr(COMPILED_VALUE_ATTRIBUTES,
1037: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) + 1,
1038: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) - 1 -
1039: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6)))) account_unit,
1040: (select FLV.MEANING
1041: from FND_LOOKUP_VALUES flv

Line 1038: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) - 1 -

1034: and language = userenv('LANG')
1035: and flv.lookup_code =
1036: (substr(COMPILED_VALUE_ATTRIBUTES,
1037: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) + 1,
1038: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) - 1 -
1039: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6)))) account_unit,
1040: (select FLV.MEANING
1041: from FND_LOOKUP_VALUES flv
1042: where flv.lookup_type = 'JA_CN_DEBIT_CREDIT'

Line 1039: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6)))) account_unit,

1035: and flv.lookup_code =
1036: (substr(COMPILED_VALUE_ATTRIBUTES,
1037: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) + 1,
1038: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) - 1 -
1039: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6)))) account_unit,
1040: (select FLV.MEANING
1041: from FND_LOOKUP_VALUES flv
1042: where flv.lookup_type = 'JA_CN_DEBIT_CREDIT'
1043: and flv.view_APPLICATION_ID = 0

Line 1047: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) + 1))) balance_side,

1043: and flv.view_APPLICATION_ID = 0
1044: and flv.security_group_id = 0
1045: and language = userenv('LANG')
1046: and flv.lookup_code = (substr(COMPILED_VALUE_ATTRIBUTES,
1047: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 7) + 1))) balance_side,
1048: to_char(nvl(b.START_DATE_ACTIVE,b.creation_date),'YYYYMMDD') START_DATE_ACTIVE,to_char(b.end_date_active,'YYYYMMDD') end_date_active
1049: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B
1050: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
1051: and T.LANGUAGE = userenv('LANG')

Line 1053: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,

1049: from FND_FLEX_VALUES_TL T, FND_FLEX_VALUES B
1050: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
1051: and T.LANGUAGE = userenv('LANG')
1052: and substr(COMPILED_VALUE_ATTRIBUTES,
1053: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,
1054: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -
1055: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'E'
1056: and b.FLEX_VALUE_SET_ID = c_flex_id;
1057:

Line 1054: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -

1050: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
1051: and T.LANGUAGE = userenv('LANG')
1052: and substr(COMPILED_VALUE_ATTRIBUTES,
1053: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,
1054: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -
1055: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'E'
1056: and b.FLEX_VALUE_SET_ID = c_flex_id;
1057:
1058: lv_procedure_name VARCHAR2(40) := 'Add_Extra_Sheet_Account';

Line 1055: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'E'

1051: and T.LANGUAGE = userenv('LANG')
1052: and substr(COMPILED_VALUE_ATTRIBUTES,
1053: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5) + 1,
1054: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 6) - 1 -
1055: instr(COMPILED_VALUE_ATTRIBUTES, fnd_global.local_chr(10), 1, 5)) = 'E'
1056: and b.FLEX_VALUE_SET_ID = c_flex_id;
1057:
1058: lv_procedure_name VARCHAR2(40) := 'Add_Extra_Sheet_Account';
1059: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;