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.

[Home] [Help]

APPS.FLM_EKB_SUMMARY_UTIL dependencies on MFG_LOOKUPS

Line 143: mfg_lookups ml,

139: l_inner_where varchar2(2000) := ' from mtl_kanban_cards mkc,
140: mtl_kanban_pull_sequences mkps,
141: mtl_item_locations_kfv srcloc,
142: mtl_item_locations_kfv destloc,
143: mfg_lookups ml,
144: mfg_lookups ml2,
145: mtl_parameters mp,
146: mtl_parameters mp2,
147: po_suppliers_val_v psv,

Line 144: mfg_lookups ml2,

140: mtl_kanban_pull_sequences mkps,
141: mtl_item_locations_kfv srcloc,
142: mtl_item_locations_kfv destloc,
143: mfg_lookups ml,
144: mfg_lookups ml2,
145: mtl_parameters mp,
146: mtl_parameters mp2,
147: po_suppliers_val_v psv,
148: mtl_system_items_kfv msik,

Line 189: -- loop through all the supply status in mfg_lookups

185: BEGIN
186: l_org_id := p_org_id;
187: l_supplier_id := p_supplier_id;
188: l_supplier_site_id := p_supplier_site_id;
189: -- loop through all the supply status in mfg_lookups
190: for c_statusRec in (select lookup_code
191: from mfg_lookups
192: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
193: order by lookup_code) loop

Line 191: from mfg_lookups

187: l_supplier_id := p_supplier_id;
188: l_supplier_site_id := p_supplier_site_id;
189: -- loop through all the supply status in mfg_lookups
190: for c_statusRec in (select lookup_code
191: from mfg_lookups
192: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
193: order by lookup_code) loop
194: l_outer_stmt := l_outer_stmt ||',sum(inner_'|| l_attr_num ||') attribute'|| l_attr_num;
195: l_inner_stmt := l_inner_stmt ||',sum(decode(supply_status,'|| c_statusRec.lookup_code || ',1)) inner_' || l_attr_num;

Line 275: mfg_lookups ml,

271: l_inner_where varchar2(2000) := ' from mtl_kanban_cards mkc,
272: mtl_kanban_pull_sequences mkps,
273: mtl_item_locations_kfv srcloc,
274: mtl_item_locations_kfv destloc,
275: mfg_lookups ml,
276: mfg_lookups ml2,
277: mtl_parameters mp,
278: po_suppliers_val_v psv,
279: mtl_system_items_kfv msik,

Line 276: mfg_lookups ml2,

272: mtl_kanban_pull_sequences mkps,
273: mtl_item_locations_kfv srcloc,
274: mtl_item_locations_kfv destloc,
275: mfg_lookups ml,
276: mfg_lookups ml2,
277: mtl_parameters mp,
278: po_suppliers_val_v psv,
279: mtl_system_items_kfv msik,
280: po_agents_name_v panv

Line 321: -- loop through all the supply status in mfg_lookups

317: BEGIN
318: l_org_id := p_org_id;
319: l_supplier_id := p_supplier_id;
320: l_supplier_site_id := p_supplier_site_id;
321: -- loop through all the supply status in mfg_lookups
322: for c_statusRec in (select lookup_code
323: from mfg_lookups
324: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
325: order by lookup_code) loop

Line 323: from mfg_lookups

319: l_supplier_id := p_supplier_id;
320: l_supplier_site_id := p_supplier_site_id;
321: -- loop through all the supply status in mfg_lookups
322: for c_statusRec in (select lookup_code
323: from mfg_lookups
324: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
325: order by lookup_code) loop
326: l_outer_stmt := l_outer_stmt ||',sum(inner_'|| l_attr_num ||') attribute'|| l_attr_num;
327: l_inner_stmt := l_inner_stmt ||',sum(decode(supply_status,'|| c_statusRec.lookup_code || ',1)) inner_' || l_attr_num;

Line 400: mfg_lookups ml,

396: l_inner_where varchar2(2000) := ' from mtl_kanban_cards mkc,
397: mtl_kanban_pull_sequences mkps,
398: mtl_item_locations_kfv srcloc,
399: mtl_item_locations_kfv destloc,
400: mfg_lookups ml,
401: mfg_lookups ml2,
402: mtl_parameters mp,
403: po_suppliers_val_v psv,
404: mtl_system_items_kfv msik,

Line 401: mfg_lookups ml2,

397: mtl_kanban_pull_sequences mkps,
398: mtl_item_locations_kfv srcloc,
399: mtl_item_locations_kfv destloc,
400: mfg_lookups ml,
401: mfg_lookups ml2,
402: mtl_parameters mp,
403: po_suppliers_val_v psv,
404: mtl_system_items_kfv msik,
405: po_agents_name_v panv,

Line 445: -- loop through all the supply status in mfg_lookups

441: l_supplier_site_id number:= null;
442:
443: BEGIN
444: l_org_id := p_org_id;
445: -- loop through all the supply status in mfg_lookups
446: for c_statusRec in (select lookup_code
447: from mfg_lookups
448: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
449: order by lookup_code) loop

Line 447: from mfg_lookups

443: BEGIN
444: l_org_id := p_org_id;
445: -- loop through all the supply status in mfg_lookups
446: for c_statusRec in (select lookup_code
447: from mfg_lookups
448: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
449: order by lookup_code) loop
450: l_outer_stmt := l_outer_stmt ||',sum(inner_'|| l_attr_num ||') attribute'|| l_attr_num;
451: l_inner_stmt := l_inner_stmt ||',sum(decode(supply_status,'|| c_statusRec.lookup_code || ',1)) inner_' || l_attr_num;