APPS.INVPPROC dependencies on FND_LANGUAGES

Line 109: AND tl.language IN (SELECT l.language_code FROM fnd_languages l

105: AND tl.unique_id = msii.transaction_id
106: AND tl.set_process_id = msii.set_process_id
107: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
108: AND UPPER(tl.column_name) = 'DESCRIPTION'
109: AND tl.language IN (SELECT l.language_code FROM fnd_languages l
110: WHERE l.installed_flag IN ('I', 'B'));
111:
112: CURSOR is_gdsn_batch(cp_xset_id NUMBER) IS
113: SELECT 1 FROM ego_import_option_sets

Line 1105: , FND_LANGUAGES L

1101: NVL(I.CREATION_DATE, l_sysdate),
1102: user_id, /* created_by */
1103: login_id /* last_update_login */
1104: from MTL_SYSTEM_ITEMS_INTERFACE I
1105: , FND_LANGUAGES L
1106: , mtl_parameters mp
1107: where I.process_flag = l_process_flag_4
1108: and I.set_process_id = xset_id
1109: and I.transaction_type = l_transaction_type

Line 1156: , FND_LANGUAGES L

1152: user_id, --* created_by
1153: login_id --* last_update_login
1154: from MTL_SYSTEM_ITEMS_INTERFACE I
1155: , MTL_SYSTEM_ITEMS_TL msitl
1156: , FND_LANGUAGES L
1157: where I.process_flag = l_process_flag_4
1158: and I.set_process_id = xset_id
1159: and I.transaction_type = l_transaction_type
1160: and L.INSTALLED_FLAG in ('I', 'B')

Line 1377: FND_LANGUAGES L

1373: r.LAST_UPDATE_LOGIN,
1374: L.LANGUAGE_CODE,
1375: USERENV('LANG')
1376: FROM MTL_ITEM_REVISIONS_INTERFACE r,
1377: FND_LANGUAGES L
1378: WHERE r.process_flag = l_process_flag_4
1379: AND r.set_process_id = xset_id
1380: AND r.transaction_type = l_transaction_type
1381: and L.INSTALLED_FLAG in ('I', 'B');