DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 550: , mtl_kanban_card_activity mka

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
553: , wip_lines wl
554: , wip_lines wl_act

Line 591: FROM mtl_kanban_card_activity mkca

587: AND mkc.organization_id = mka.organization_id(+)
588: AND mkc.kanban_card_id = mka.kanban_card_id(+)
589: AND NVL(TO_CHAR(mka.last_update_date, 'DD-MON-YYYY HH24:MI:SS'), '01/01/1111 00:00:00') =
590: (SELECT NVL(TO_CHAR(MAX(last_update_date), 'DD-MON-YYYY HH24:MI:SS'), '01/01/1111 00:00:00')
591: FROM mtl_kanban_card_activity mkca
592: WHERE NVL(mkca.kanban_card_id, mkc.kanban_card_id) = mkc.kanban_card_id)
593: AND mfg1.lookup_type = 'MTL_KANBAN_CARD_TYPE'
594: AND mfg1.lookup_code = mkc.kanban_card_type
595: AND mfg2.lookup_type = 'MTL_KANBAN_CARD_STATUS'