DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 539: , mtl_kanban_card_activity mka

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
542: , wip_lines wl
543: , wip_lines wl_act

Line 580: FROM mtl_kanban_card_activity mkca

576: AND mkc.organization_id = mka.organization_id(+)
577: AND mkc.kanban_card_id = mka.kanban_card_id(+)
578: AND NVL(TO_CHAR(mka.last_update_date, 'DD-MON-YYYY HH24:MI:SS'), '01/01/1111 00:00:00') =
579: (SELECT NVL(TO_CHAR(MAX(last_update_date), 'DD-MON-YYYY HH24:MI:SS'), '01/01/1111 00:00:00')
580: FROM mtl_kanban_card_activity mkca
581: WHERE NVL(mkca.kanban_card_id, mkc.kanban_card_id) = mkc.kanban_card_id)
582: AND mfg1.lookup_type = 'MTL_KANBAN_CARD_TYPE'
583: AND mfg1.lookup_code = mkc.kanban_card_type
584: AND mfg2.lookup_type = 'MTL_KANBAN_CARD_STATUS'