DBA Data[Home] [Help]

APPS.FLM_EKB_ACTUAL_DEMAND dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 175: FROM MTL_KANBAN_CARD_ACTIVITY MKCA

171: G_USER_ID,
172: sysdate,
173: G_USER_ID,
174: null
175: FROM MTL_KANBAN_CARD_ACTIVITY MKCA
176: WHERE KANBAN_CARD_ID = c_card_activity.kanban_card_id
177: AND ( ( SUPPLY_STATUS >= 4 AND SUPPLY_STATUS < 5 AND SOURCE_TYPE <> 3 ) OR
178: ( SUPPLY_STATUS >= 5 AND SUPPLY_STATUS < 6 AND SOURCE_TYPE = 3 )
179: ) -- Supply status Inprocess for Intra org kanban and Empty for other kanban types

Line 187: from MTL_KANBAN_CARD_ACTIVITY MKCA

183:
184:
185: Update FLM_EKB_ACT_SNAPSHOT FEAS
186: Set ( REPLENISHMENT_DATE , KANBAN_SIZE ) = (Select CREATION_DATE,KANBAN_SIZE
187: from MTL_KANBAN_CARD_ACTIVITY MKCA
188: where MKCA.Kanban_Activity_id = FEAS.REPLENISHMENT_ACTIVITY_ID)
189: where REPLENISHMENT_DATE is null;
190:
191: