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.WMS_WAVE_PLANNING_PVT dependencies on MFG_LOOKUPS

Line 17882: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;

17878: end;
17879:
17880: PROCEDURE insert_global_temp(p_wave_header_id IN number)
17881: IS
17882: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;
17883: type lookup_meaning_codes IS TABLE OF mfg_lookups.lookup_code%TYPE INDEX BY BINARY_INTEGER;
17884: l_plan_task_types lookup_meaning_table; --12693583
17885: l_plan_task_types_temp lookup_meaning_table; --12693583
17886: l_plan_task_type_codes lookup_meaning_codes; --12693583

Line 17883: type lookup_meaning_codes IS TABLE OF mfg_lookups.lookup_code%TYPE INDEX BY BINARY_INTEGER;

17879:
17880: PROCEDURE insert_global_temp(p_wave_header_id IN number)
17881: IS
17882: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;
17883: type lookup_meaning_codes IS TABLE OF mfg_lookups.lookup_code%TYPE INDEX BY BINARY_INTEGER;
17884: l_plan_task_types lookup_meaning_table; --12693583
17885: l_plan_task_types_temp lookup_meaning_table; --12693583
17886: l_plan_task_type_codes lookup_meaning_codes; --12693583
17887:

Line 17892: from mfg_lookups

17888: BEGIN
17889:
17890: --12693583...store table for task types string translation
17891: select lookup_code, REPLACE (meaning, '''', '''''') bulk collect into l_plan_task_type_codes, l_plan_task_types_temp
17892: from mfg_lookups
17893: where lookup_type = 'WMS_PLAN_TASK_TYPES'
17894: order by lookup_code;
17895:
17896: for i in l_plan_task_type_codes.first .. l_plan_task_type_codes.last loop

Line 18307: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583

18303: decode(wdt.status,
18304: null,
18305: nvl(mmtt.wms_task_status, 1),
18306: wdt.status) status_id_original,
18307: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583
18308: mmtt.last_update_date mmtt_last_update_date,
18309: mmtt.last_updated_by mmtt_last_update_by,
18310: wdt.last_update_date wdt_last_update_date,
18311: wdt.last_updated_by wdt_last_update_by,

Line 18315: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583

18311: wdt.last_updated_by wdt_last_update_by,
18312: mmtt.task_priority,
18313: mmtt.task_priority priority_original,
18314: mmtt.wms_task_type task_type_id,
18315: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583
18316: 'N' is_modified,
18317: decode(mmtt.parent_line_id,
18318: null,
18319: decode(mmtt.operation_plan_id,

Line 18456: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583

18452: decode(wdt.status,
18453: null,
18454: nvl(mmtt.wms_task_status, 1),
18455: wdt.status) status_id_original,
18456: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583
18457: mmtt.last_update_date mmtt_last_update_date,
18458: mmtt.last_updated_by mmtt_last_update_by,
18459: wdt.last_update_date wdt_last_update_date,
18460: wdt.last_updated_by wdt_last_update_by,

Line 18464: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583

18460: wdt.last_updated_by wdt_last_update_by,
18461: mmtt.task_priority,
18462: mmtt.task_priority priority_original,
18463: mmtt.wms_task_type task_type_id,
18464: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583
18465: 'N' is_modified,
18466: l_plan_task_types(4) plan_task, --12693583, 12736677
18467: ' ' result,
18468: ' ' error,

Line 18588: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583

18584: decode(wdt.status,
18585: null,
18586: nvl(mmtt.wms_task_status, 1),
18587: wdt.status) status_id_original,
18588: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583
18589: mmtt.last_update_date mmtt_last_update_date,
18590: mmtt.last_updated_by mmtt_last_update_by,
18591: wdt.last_update_date wdt_last_update_date,
18592: wdt.last_updated_by wdt_last_update_by,

Line 18596: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583

18592: wdt.last_updated_by wdt_last_update_by,
18593: mmtt.task_priority,
18594: mmtt.task_priority priority_original,
18595: mmtt.wms_task_type task_type_id,
18596: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583
18597: 'N' is_modified,
18598: decode(mmtt.parent_line_id,
18599: null,
18600: decode(mmtt.operation_plan_id,

Line 18737: FROM mfg_lookups

18733: br1.resource_code,
18734: 6 status_id,
18735: 6 status_id_original,
18736: (SELECT meaning
18737: FROM mfg_lookups
18738: WHERE lookup_type = 'WMS_TASK_STATUS'
18739: AND lookup_code = 6) STATUS,
18740: to_date(null)mmtt_last_update_date,
18741: NULL mmtt_last_updated_by,

Line 18747: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =wdth.task_type) task_type, --12693583

18743: NULL wdt_last_updated_by,
18744: wdth.priority,
18745: wdth.priority priority_original,
18746: wdth.task_type task_type_id,
18747: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =wdth.task_type) task_type, --12693583
18748: 'N' is_modified,
18749: decode(wdth.is_parent,
18750: 'Y',
18751: decode(wdth.transaction_action_id,

Line 18925: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583

18921: decode(wdt.status,
18922: null,
18923: nvl(mmtt.wms_task_status, 1),
18924: wdt.status) status_id_original,
18925: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_STATUS' and lookup_code = decode(wdt.status,null, nvl(mmtt.wms_task_status,1), wdt.status)) STATUS, --12693583
18926: mmtt.last_update_date mmtt_last_update_date,
18927: mmtt.last_updated_by mmtt_last_update_by,
18928: wdt.last_update_date wdt_last_update_date,
18929: wdt.last_updated_by wdt_last_update_by,

Line 18933: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583

18929: wdt.last_updated_by wdt_last_update_by,
18930: mmtt.task_priority,
18931: mmtt.task_priority priority_original,
18932: mmtt.wms_task_type task_type_id,
18933: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =mmtt.wms_task_type) task_type, --12693583
18934: 'N' is_modified,
18935: decode(mmtt.parent_line_id,
18936: null,
18937: decode(mmtt.operation_plan_id,

Line 19070: FROM mfg_lookups

19066: br1.resource_code,
19067: 6 status_id,
19068: 6 status_id_original,
19069: (SELECT meaning
19070: FROM mfg_lookups
19071: WHERE lookup_type = 'WMS_TASK_STATUS'
19072: AND lookup_code = 6) STATUS,
19073: to_date(null)mmtt_last_update_date,
19074: NULL mmtt_last_updated_by,

Line 19080: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =wdth.task_type) task_type, --12693583

19076: NULL wdt_last_updated_by,
19077: wdth.priority,
19078: wdth.priority priority_original,
19079: wdth.task_type task_type_id,
19080: (select meaning from mfg_lookups where lookup_type = 'WMS_TASK_TYPES' and lookup_code =wdth.task_type) task_type, --12693583
19081: 'N' is_modified,
19082: decode(wdth.is_parent,
19083: 'Y',
19084: decode(wdth.transaction_action_id,