DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on MFG_LOOKUPS

Line 11225: from mfg_lookups

11221: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11222: l_stmt_num := 960.1;
11223: select meaning
11224: into l_meaning
11225: from mfg_lookups
11226: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11227: and lookup_code = 7
11228: and upper(enabled_flag) = 'Y';
11229:

Line 11783: from mfg_lookups

11779: -- bug 5051885
11780: l_stmt_num := 1040.2;
11781: select meaning
11782: into l_job_type_code
11783: from mfg_lookups
11784: where lookup_type = 'WIP_DISCRETE_JOB'
11785: and lookup_code = v_wlji_job_type(v_idx);
11786:
11787: l_stmt_num := 1040.3;

Line 11847: from mfg_lookups

11843: l_error_code := -1;
11844: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11845: select meaning
11846: into l_meaning
11847: from mfg_lookups
11848: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11849: and lookup_code = 7
11850: and upper(enabled_flag) = 'Y';
11851:

Line 13594: from mfg_lookups

13590: else
13591: begin
13592: select 1
13593: into l_dummy
13594: from mfg_lookups
13595: where LOOKUP_TYPE = 'BOM_RESOURCE_SCHEDULE_TYPE'
13596: and lookup_code = p_new_res_tbl(l_index).scheduled_flag;
13597: exception
13598: when others then

Line 21324: from mfg_lookups

21320:
21321: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
21322: select meaning
21323: into l_translated_meaning
21324: from mfg_lookups
21325: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
21326: and lookup_code = 5
21327: and upper(enabled_flag) = 'Y';
21328: