DBA Data[Home] [Help]

APPS.JA_CN_SI_BANK_DET_PKG dependencies on FND_LOOKUP_VALUES

Line 851: from FND_LOOKUP_VALUES flv

847: select b.flex_value,
848: t.description,
849: NULL acc_level,
850: (select FLV.MEANING
851: from FND_LOOKUP_VALUES flv
852: where flv.lookup_type = 'ACCOUNT_TYPE'
853: and flv.view_APPLICATION_ID = 0
854: and flv.security_group_id = 0
855: and language = userenv('LANG')

Line 862: from FND_LOOKUP_VALUES flv

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
865: and flv.security_group_id = 0
866: and language = userenv('LANG')

Line 1019: from FND_LOOKUP_VALUES flv

1015: select b.flex_value,COMPILED_VALUE_ATTRIBUTES,
1016: t.description,
1017: NULL acc_level,
1018: (select FLV.MEANING
1019: from FND_LOOKUP_VALUES flv
1020: where flv.lookup_type = 'ACCOUNT_TYPE'
1021: and flv.view_APPLICATION_ID = 0
1022: and flv.security_group_id = 0
1023: and language = userenv('LANG')

Line 1030: from FND_LOOKUP_VALUES flv

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
1033: and flv.security_group_id = 0
1034: and language = userenv('LANG')

Line 1041: from FND_LOOKUP_VALUES flv

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
1044: and flv.security_group_id = 0
1045: and language = userenv('LANG')