eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_EKB_LEAD_TIME dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 172: FROM MTL_KANBAN_CARD_ACTIVITY MKCA

168: KANBAN_ACTIVITY_ID,
169: CREATION_DATE
170: into l_kanban_activity_id,
171: l_recv_date
172: FROM MTL_KANBAN_CARD_ACTIVITY MKCA
173: WHERE KANBAN_CARD_ID = c_card_activity.kanban_card_id
174: AND SUPPLY_STATUS >= 2 AND SUPPLY_STATUS < 3 -- Supply Status Full
175: AND KANBAN_ACTIVITY_ID = ( select min(kanban_activity_id)
176: from MTL_KANBAN_CARD_ACTIVITY

Line 176: from MTL_KANBAN_CARD_ACTIVITY

172: FROM MTL_KANBAN_CARD_ACTIVITY MKCA
173: WHERE KANBAN_CARD_ID = c_card_activity.kanban_card_id
174: AND SUPPLY_STATUS >= 2 AND SUPPLY_STATUS < 3 -- Supply Status Full
175: AND KANBAN_ACTIVITY_ID = ( select min(kanban_activity_id)
176: from MTL_KANBAN_CARD_ACTIVITY
177: where KANBAN_CARD_ID = c_card_activity.kanban_card_id
178: AND SUPPLY_STATUS >= 2 AND SUPPLY_STATUS < 3 -- Supply Status Full
179: AND CREATION_DATE > l_last_run_date
180: AND KANBAN_ACTIVITY_ID > c_card_activity.REPLENISHMENT_activity_id)