APPS.FLM_EKB_UNMOVED_CARDS dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 157: FROM MTL_KANBAN_PULL_SEQUENCES MKPS , MTL_KANBAN_CARDS MKC,

153: MKPS.PULL_SEQUENCE_ID,
154: MKC.KANBAN_CARD_ID,
155: MKPS.ORGANIZATION_ID,
156: MKPS.REPLENISHMENT_LEAD_TIME
157: FROM MTL_KANBAN_PULL_SEQUENCES MKPS , MTL_KANBAN_CARDS MKC,
158: MTL_KANBAN_CARD_ACTIVITY MKCA
159: where MKPS.ORGANIZATION_ID = p_organization_id
160: and MKPS.PULL_SEQUENCE_ID = MKC.PULL_SEQUENCE_ID
161: and MKPS.REPLENISHMENT_LEAD_TIME > 0

Line 175: MTL_KANBAN_PULL_SEQUENCES where ORGANIZATION_ID = p_organization_id );

171:
172: Update MTL_KANBAN_CARDS
173: Set MOVE_STATUS = null
174: where pull_sequence_id in ( select pull_sequence_id from
175: MTL_KANBAN_PULL_SEQUENCES where ORGANIZATION_ID = p_organization_id );
176:
177: -- l_unmoved_lead_table := flm_unmoved_lead_table;
178: l_unmoved_table := flm_kanban_config_params.get_unmovedcard_leadtime(p_org_id => p_organization_id);
179: if l_unmoved_table.count = 0 then