DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on MFG_LOOKUPS

Line 11327: from mfg_lookups

11323: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11324: l_stmt_num := 960.1;
11325: select meaning
11326: into l_meaning
11327: from mfg_lookups
11328: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11329: and lookup_code = 7
11330: and upper(enabled_flag) = 'Y';
11331:

Line 11887: from mfg_lookups

11883: -- bug 5051885
11884: l_stmt_num := 1040.2;
11885: select meaning
11886: into l_job_type_code
11887: from mfg_lookups
11888: where lookup_type = 'WIP_DISCRETE_JOB'
11889: and lookup_code = v_wlji_job_type(v_idx);
11890:
11891: l_stmt_num := 1040.3;

Line 11951: from mfg_lookups

11947: l_error_code := -1;
11948: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11949: select meaning
11950: into l_meaning
11951: from mfg_lookups
11952: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11953: and lookup_code = 7
11954: and upper(enabled_flag) = 'Y';
11955:

Line 13698: from mfg_lookups

13694: else
13695: begin
13696: select 1
13697: into l_dummy
13698: from mfg_lookups
13699: where LOOKUP_TYPE = 'BOM_RESOURCE_SCHEDULE_TYPE'
13700: and lookup_code = p_new_res_tbl(l_index).scheduled_flag;
13701: exception
13702: when others then

Line 21990: from mfg_lookups

21986:
21987: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
21988: select meaning
21989: into l_translated_meaning
21990: from mfg_lookups
21991: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
21992: and lookup_code = 5
21993: and upper(enabled_flag) = 'Y';
21994: