APPS.FLM_KANBAN_CONFIG_PARAMS dependencies on MFG_LOOKUPS

Line 497: from mfg_lookups ml

493: l_lookup_type varchar2(30);
494:
495: cursor lookup_meaning (cl_value_code varchar2, c1_lookup_type varchar2) is
496: select ml.meaning
497: from mfg_lookups ml
498: where ml.lookup_code = to_number(cl_value_code) and
499: ml.lookup_type = c1_lookup_type;
500:
501: /* (select wp.preference_value_lookup_type

Line 698: from mfg_lookups ml

694: l_params flm_ekanban_logger.param_tbl_t;
695:
696: cursor c_unmovedcard_status IS
697: select ml.lookup_code
698: from mfg_lookups ml
699: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
700: and to_number(ml.lookup_code) <= 8 /*only system/custom statuses till 8 will be honored in ekanban*/
701: and ml.enabled_flag = 'Y' /*consider only enabled status*/
702: and (ml.end_date_active is null OR ml.end_date_active > sysdate) /*consider status with future end date*/

Line 878: from mfg_lookups ml

874: where preference_id = 13
875: and level_id = l_level_id
876: and attribute_name not in (
877: select ml.lookup_code
878: from mfg_lookups ml
879: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
880: and to_number(ml.lookup_code) <= 8 /*only system/custom statuses till 8 will be honored in ekanban*/
881: and ml.enabled_flag = 'Y' /*consider only enabled status*/
882: and (ml.end_date_active is null OR ml.end_date_active > sysdate));

Line 902: from mfg_lookups ml

898: function get_preference_value_label(p_preference_id number, p_label_code varchar2) return varchar2 is
899: l_label_meaning varchar2(30);
900: begin
901: select ml.meaning into l_label_meaning
902: from mfg_lookups ml
903: where lookup_code = p_label_code and
904: lookup_type in
905: (
906: select preference_name_lookup_type from flm_ekb_preference_definitions

Line 915: from mfg_lookups ml

911:
912: function get_lookup_meaning(p_lookup_type varchar2, p_lookup_code varchar2) return varchar2 is
913: cursor lookup_meaning (p_lookup_type varchar2, p_lookup_code varchar2) is
914: select ml.meaning
915: from mfg_lookups ml
916: where ml.lookup_code = to_number(p_lookup_code)
917: and ml.lookup_type = p_lookup_type;
918: l_ret_val varchar2(30);
919: begin

Line 966: select ml.meaning from mfg_lookups ml

962: end;
963:
964: function get_new_enabled_status(p_org_id number) return varchar2 is
965: cursor new_enabled_status (p_level_id number) is
966: select ml.meaning from mfg_lookups ml
967: where ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
968: and ml.lookup_code not in
969: (
970: select attribute_name

Line 1010: from mfg_lookups ml

1006: where v.attribute_name in
1007: (
1008: --list of disabled codes
1009: select to_char(ml.lookup_code)
1010: from mfg_lookups ml
1011: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
1012: and (enabled_flag = 'N' or ml.end_date_active <= sysdate)
1013: )
1014: and v.level_id = p_level_id;

Line 1029: from mfg_lookups ml

1025: l_level_id := get_level_id(p_org_id);
1026: end if;
1027: for c_new_disabled_status in new_disabled_status(l_level_id) loop
1028: select ml.meaning into l_meaning
1029: from mfg_lookups ml
1030: where ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
1031: and ml.lookup_code = c_new_disabled_status.attribute_name;
1032: l_ret_val := l_ret_val || l_meaning || ', ';
1033: end loop;