APPS.INV_KANBAN_PKG dependencies on MFG_LOOKUPS

Line 455: FROM mfg_lookups

451: BEGIN
452: OPEN x_kanban_ref FOR
453: SELECT DISTINCT meaning
454: , lookup_code
455: FROM mfg_lookups
456: WHERE lookup_code IN (1, 2, 3, 4)
457: AND meaning LIKE (p_source_type)
458: AND lookup_type = 'MTL_KANBAN_SOURCE_TYPE';
459: END getsourcetypelov;

Line 543: , mfg_lookups mfg1

539: , pvsa_act.vendor_site_code vendor_site_last_activity
540: , wl_act.line_code
541: FROM mtl_kanban_cards mkc
542: , mtl_system_items_vl msiv
543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5

Line 544: , mfg_lookups mfg2

540: , wl_act.line_code
541: FROM mtl_kanban_cards mkc
542: , mtl_system_items_vl msiv
543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5
548: , mfg_lookups mfg6

Line 545: , mfg_lookups mfg3

541: FROM mtl_kanban_cards mkc
542: , mtl_system_items_vl msiv
543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5
548: , mfg_lookups mfg6
549: , po_vendors pv

Line 546: , mfg_lookups mfg4

542: , mtl_system_items_vl msiv
543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5
548: , mfg_lookups mfg6
549: , po_vendors pv
550: , mtl_kanban_card_activity mka

Line 547: , mfg_lookups mfg5

543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5
548: , mfg_lookups mfg6
549: , po_vendors pv
550: , mtl_kanban_card_activity mka
551: , po_vendor_sites_all pvsa

Line 548: , mfg_lookups mfg6

544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5
548: , mfg_lookups mfg6
549: , po_vendors pv
550: , mtl_kanban_card_activity mka
551: , po_vendor_sites_all pvsa
552: , mtl_kanban_pull_sequences mkps

Line 704: , mfg_lookups ml

700: , mkc.supply_status
701: , status_check(mkc.supply_status, 4) status_check
702: , ml.meaning supply_status_meaning
703: FROM mtl_kanban_cards mkc
704: , mfg_lookups ml
705: WHERE mkc.organization_id = p_organization_id
706: AND mkc.kanban_card_number = p_kanban_number
707: AND ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
708: AND mkc.supply_status = ml.lookup_code