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.BOM_BULKLOAD_PVT_PKG dependencies on FND_LOOKUP_VALUES

Line 1087: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Fnd_Lookup_Values WHERE Lookup_Type = ''BOM_EFFECTIVITY_CONTROL'' AND LANGUAGE=USERENV(''LANG'') AND Meaning=' || G_INTF_EFFEC_CONTROL || ')';

1083: ||' :2 ),'|| G_INTF_STRUCT_NAME|| ')' || ')';
1084: l_dyn_sql_select := l_dyn_sql_select || ' , ' || 'DECODE(' || G_INTF_STR_TYPE_NAME
1085: ||',null,(SELECT BSTV.structure_type_name from bom_structure_types_vl BSTV,ego_import_option_sets EIOS WHERE EIOS.batch_id = '
1086: || ' :3 AND BSTV.structure_type_id = EIOS.structure_type_id ),' || G_INTF_STR_TYPE_NAME || ' )';
1087: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Fnd_Lookup_Values WHERE Lookup_Type = ''BOM_EFFECTIVITY_CONTROL'' AND LANGUAGE=USERENV(''LANG'') AND Meaning=' || G_INTF_EFFEC_CONTROL || ')';
1088: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Fnd_Lookup_Values WHERE Lookup_Type = ''EGO_YES_NO'' AND LANGUAGE=USERENV(''LANG'') AND Meaning = ' || G_INTF_IS_PREFERRED || ')';
1089: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Mfg_Lookups WHERE Lookup_Type = ''BOM_ASSEMBLY_TYPE'' AND Meaning=' || G_INTF_ASSEMBLY_TYPE || ')';
1090: l_dyn_sql_select := l_dyn_sql_select || ' , ' || G_INTF_REVISION || ' ';
1091: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF WHERE RESULTFMT_USAGE_ID = :4 ';

Line 1088: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Fnd_Lookup_Values WHERE Lookup_Type = ''EGO_YES_NO'' AND LANGUAGE=USERENV(''LANG'') AND Meaning = ' || G_INTF_IS_PREFERRED || ')';

1084: l_dyn_sql_select := l_dyn_sql_select || ' , ' || 'DECODE(' || G_INTF_STR_TYPE_NAME
1085: ||',null,(SELECT BSTV.structure_type_name from bom_structure_types_vl BSTV,ego_import_option_sets EIOS WHERE EIOS.batch_id = '
1086: || ' :3 AND BSTV.structure_type_id = EIOS.structure_type_id ),' || G_INTF_STR_TYPE_NAME || ' )';
1087: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Fnd_Lookup_Values WHERE Lookup_Type = ''BOM_EFFECTIVITY_CONTROL'' AND LANGUAGE=USERENV(''LANG'') AND Meaning=' || G_INTF_EFFEC_CONTROL || ')';
1088: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Fnd_Lookup_Values WHERE Lookup_Type = ''EGO_YES_NO'' AND LANGUAGE=USERENV(''LANG'') AND Meaning = ' || G_INTF_IS_PREFERRED || ')';
1089: l_dyn_sql_select := l_dyn_sql_select || ' , (SELECT Lookup_Code FROM Mfg_Lookups WHERE Lookup_Type = ''BOM_ASSEMBLY_TYPE'' AND Meaning=' || G_INTF_ASSEMBLY_TYPE || ')';
1090: l_dyn_sql_select := l_dyn_sql_select || ' , ' || G_INTF_REVISION || ' ';
1091: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF WHERE RESULTFMT_USAGE_ID = :4 ';
1092: --Sreejith

Line 1197: Fnd_Lookup_Values

1193: Lookup_Code
1194: INTO
1195: l_eff_ctrl
1196: FROM
1197: Fnd_Lookup_Values
1198: WHERE
1199: Lookup_Type = 'BOM_EFFECTIVITY_CONTROL' AND LANGUAGE=USERENV('LANG') AND Meaning=L_EFFEC_CONTROL;
1200: ELSE
1201: l_eff_ctrl := null;

Line 1210: Fnd_Lookup_Values

1206: Lookup_Code
1207: INTO
1208: l_is_preferred
1209: FROM
1210: Fnd_Lookup_Values
1211: WHERE
1212: Lookup_Type = 'EGO_YES_NO' AND LANGUAGE=USERENV('LANG') AND Meaning=L_IS_PREF_MEANING;
1213: ELSE
1214: l_is_preferred := null;

Line 1386: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';

1382: -- As date values are coming as character values convert them as dates.
1383: IF ((l_bom_col_type(i) IS NOT NULL) AND (l_bom_col_type(i) = 'DATETIME')) THEN
1384: l_dyn_sql_select := l_dyn_sql_select || 'TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS''),';
1385: ELSIF (l_lookup_type(i) IS NOT NULL) THEN
1386: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';
1387: l_str := l_str || ' LOOKUP_TYPE = ''' || l_lookup_type(i) ||''' AND LANGUAGE = USERENV(''LANG'') AND MEANING=' || l_intf_col_name_tbl(i) ||' ),';
1388: l_dyn_sql_select := l_dyn_sql_select || l_str;
1389: ELSE
1390: l_dyn_sql_select := l_dyn_sql_select || l_intf_col_name_tbl(i) || ',';

Line 1460: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';

1456: -- As date values are coming as character values convert them as dates.
1457: IF ((l_bom_col_type(i) IS NOT NULL) AND (l_bom_col_type(i) = 'DATETIME')) THEN
1458: l_dyn_sql_select := l_dyn_sql_select || 'TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS''),';
1459: ELSIF (l_lookup_type(i) IS NOT NULL) THEN
1460: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';
1461: l_str := l_str || ' LOOKUP_TYPE = ''' || l_lookup_type(i) ||''' AND LANGUAGE = USERENV(''LANG'') AND MEANING=' || l_intf_col_name_tbl(i) ||' ),';
1462: l_dyn_sql_select := l_dyn_sql_select || l_str;
1463: ELSE
1464: l_dyn_sql_select := l_dyn_sql_select || l_intf_col_name_tbl(i) || ',';

Line 1539: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';

1535: -- As date values are coming as character values convert them as dates.
1536: IF ((l_bom_col_type(i) IS NOT NULL) AND (l_bom_col_type(i) = 'DATETIME')) THEN
1537: l_dyn_sql_select := l_dyn_sql_select || 'TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS''),';
1538: ELSIF (l_lookup_type(i) IS NOT NULL) THEN
1539: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';
1540: l_str := l_str || ' LOOKUP_TYPE = ''' || l_lookup_type(i) ||''' AND LANGUAGE = USERENV(''LANG'') AND MEANING=' || l_intf_col_name_tbl(i) ||' ),';
1541: l_dyn_sql_select := l_dyn_sql_select || l_str;
1542: ELSE
1543: l_dyn_sql_select := l_dyn_sql_select || l_intf_col_name_tbl(i) || ',';