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 1048: 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 || ')';

1044: ||' :2 ),'|| G_INTF_STRUCT_NAME|| ')' || ')';
1045: l_dyn_sql_select := l_dyn_sql_select || ' , ' || 'DECODE(' || G_INTF_STR_TYPE_NAME
1046: ||',null,(SELECT BSTV.structure_type_name from bom_structure_types_vl BSTV,ego_import_option_sets EIOS WHERE EIOS.batch_id = '
1047: || ' :3 AND BSTV.structure_type_id = EIOS.structure_type_id ),' || G_INTF_STR_TYPE_NAME || ' )';
1048: 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 || ')';
1049: 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 || ')';
1050: 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 || ')';
1051: l_dyn_sql_select := l_dyn_sql_select || ' , ' || G_INTF_REVISION || ' ';
1052: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF WHERE RESULTFMT_USAGE_ID = :4 ';

Line 1049: 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 || ')';

1045: l_dyn_sql_select := l_dyn_sql_select || ' , ' || 'DECODE(' || G_INTF_STR_TYPE_NAME
1046: ||',null,(SELECT BSTV.structure_type_name from bom_structure_types_vl BSTV,ego_import_option_sets EIOS WHERE EIOS.batch_id = '
1047: || ' :3 AND BSTV.structure_type_id = EIOS.structure_type_id ),' || G_INTF_STR_TYPE_NAME || ' )';
1048: 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 || ')';
1049: 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 || ')';
1050: 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 || ')';
1051: l_dyn_sql_select := l_dyn_sql_select || ' , ' || G_INTF_REVISION || ' ';
1052: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF WHERE RESULTFMT_USAGE_ID = :4 ';
1053: --Sreejith

Line 1158: Fnd_Lookup_Values

1154: Lookup_Code
1155: INTO
1156: l_eff_ctrl
1157: FROM
1158: Fnd_Lookup_Values
1159: WHERE
1160: Lookup_Type = 'BOM_EFFECTIVITY_CONTROL' AND LANGUAGE=USERENV('LANG') AND Meaning=L_EFFEC_CONTROL;
1161: ELSE
1162: l_eff_ctrl := null;

Line 1171: Fnd_Lookup_Values

1167: Lookup_Code
1168: INTO
1169: l_is_preferred
1170: FROM
1171: Fnd_Lookup_Values
1172: WHERE
1173: Lookup_Type = 'EGO_YES_NO' AND LANGUAGE=USERENV('LANG') AND Meaning=L_IS_PREF_MEANING;
1174: ELSE
1175: l_is_preferred := null;

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

1333: -- As date values are coming as character values convert them as dates.
1334: IF ((l_bom_col_type(i) IS NOT NULL) AND (l_bom_col_type(i) = 'DATETIME')) THEN
1335: l_dyn_sql_select := l_dyn_sql_select || 'TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS''),';
1336: ELSIF (l_lookup_type(i) IS NOT NULL) THEN
1337: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';
1338: l_str := l_str || ' LOOKUP_TYPE = ''' || l_lookup_type(i) ||''' AND LANGUAGE = USERENV(''LANG'') AND MEANING=' || l_intf_col_name_tbl(i) ||' ),';
1339: l_dyn_sql_select := l_dyn_sql_select || l_str;
1340: ELSE
1341: l_dyn_sql_select := l_dyn_sql_select || l_intf_col_name_tbl(i) || ',';

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

1407: -- As date values are coming as character values convert them as dates.
1408: IF ((l_bom_col_type(i) IS NOT NULL) AND (l_bom_col_type(i) = 'DATETIME')) THEN
1409: l_dyn_sql_select := l_dyn_sql_select || 'TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS''),';
1410: ELSIF (l_lookup_type(i) IS NOT NULL) THEN
1411: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';
1412: l_str := l_str || ' LOOKUP_TYPE = ''' || l_lookup_type(i) ||''' AND LANGUAGE = USERENV(''LANG'') AND MEANING=' || l_intf_col_name_tbl(i) ||' ),';
1413: l_dyn_sql_select := l_dyn_sql_select || l_str;
1414: ELSE
1415: l_dyn_sql_select := l_dyn_sql_select || l_intf_col_name_tbl(i) || ',';

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

1478: -- As date values are coming as character values convert them as dates.
1479: IF ((l_bom_col_type(i) IS NOT NULL) AND (l_bom_col_type(i) = 'DATETIME')) THEN
1480: l_dyn_sql_select := l_dyn_sql_select || 'TO_DATE(' || l_intf_col_name_tbl(i) || ',''DD-MON-YYYY HH24:MI:SS''),';
1481: ELSIF (l_lookup_type(i) IS NOT NULL) THEN
1482: l_str := '(SELECT LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE ';
1483: l_str := l_str || ' LOOKUP_TYPE = ''' || l_lookup_type(i) ||''' AND LANGUAGE = USERENV(''LANG'') AND MEANING=' || l_intf_col_name_tbl(i) ||' ),';
1484: l_dyn_sql_select := l_dyn_sql_select || l_str;
1485: ELSE
1486: l_dyn_sql_select := l_dyn_sql_select || l_intf_col_name_tbl(i) || ',';