APPS.FLM_EKB_HEALTH_STATUS dependencies on MTL_KANBAN_CARDS

Line 109: FROM MTL_KANBAN_CARDS

105: Cursor c_cards_for_ps (l_pull_sequence_id number )is
106: select
107: COUNT(KANBAN_CARD_ID) Total_cards,
108: nvl(SUM(KANBAN_SIZE),0) Total_size
109: FROM MTL_KANBAN_CARDS
110: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id
111: AND SUPPLY_STATUS >= 2 AND SUPPLY_STATUS < 3 --Supply Status Full
112: AND CARD_STATUS in (1,2); /*Bug 14262914:Only considering Active and Hold card*/
113: