DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on MFG_LOOKUPS

Line 444: FROM mfg_lookups

440: BEGIN
441: OPEN x_kanban_ref FOR
442: SELECT DISTINCT meaning
443: , lookup_code
444: FROM mfg_lookups
445: WHERE lookup_code IN (1, 2, 3, 4)
446: AND meaning LIKE (p_source_type)
447: AND lookup_type = 'MTL_KANBAN_SOURCE_TYPE';
448: END getsourcetypelov;

Line 532: , mfg_lookups mfg1

528: , pvsa_act.vendor_site_code vendor_site_last_activity
529: , wl_act.line_code
530: FROM mtl_kanban_cards mkc
531: , mtl_system_items_vl msiv
532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5

Line 533: , mfg_lookups mfg2

529: , wl_act.line_code
530: FROM mtl_kanban_cards mkc
531: , mtl_system_items_vl msiv
532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5
537: , mfg_lookups mfg6

Line 534: , mfg_lookups mfg3

530: FROM mtl_kanban_cards mkc
531: , mtl_system_items_vl msiv
532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5
537: , mfg_lookups mfg6
538: , po_vendors pv

Line 535: , mfg_lookups mfg4

531: , mtl_system_items_vl msiv
532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5
537: , mfg_lookups mfg6
538: , po_vendors pv
539: , mtl_kanban_card_activity mka

Line 536: , mfg_lookups mfg5

532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5
537: , mfg_lookups mfg6
538: , po_vendors pv
539: , mtl_kanban_card_activity mka
540: , po_vendor_sites_all pvsa

Line 537: , mfg_lookups mfg6

533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5
537: , mfg_lookups mfg6
538: , po_vendors pv
539: , mtl_kanban_card_activity mka
540: , po_vendor_sites_all pvsa
541: , mtl_kanban_pull_sequences mkps

Line 693: , mfg_lookups ml

689: , mkc.supply_status
690: , status_check(mkc.supply_status, 4) status_check
691: , ml.meaning supply_status_meaning
692: FROM mtl_kanban_cards mkc
693: , mfg_lookups ml
694: WHERE mkc.organization_id = p_organization_id
695: AND mkc.kanban_card_number = p_kanban_number
696: AND ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
697: AND mkc.supply_status = ml.lookup_code