APPS.FLM_LOGICAL_KANBAN dependencies on MTL_KANBAN_CARDS

Line 74: FROM mtl_kanban_cards

70: ORDER BY mkps.pull_sequence_id;
71:
72: CURSOR kanban_cur(pull_seq_id NUMBER) IS
73: SELECT *
74: FROM mtl_kanban_cards
75: WHERE organization_id = p_organizationID
76: AND pull_sequence_id = pull_seq_id;
77:
78: CURSOR mul_sup_cur(pull_seq_id NUMBER) IS

Line 202: mtl_kanban_cards mkc

198: SELECT Nvl(Sum(mmt.transaction_quantity),0)
199: INTO l_received_quantity
200: FROM mtl_material_transactions mmt,
201: mtl_kanban_card_activity mkca,
202: mtl_kanban_cards mkc
203: WHERE mkca.kanban_card_id = kanban_rec.Kanban_Card_Id
204: AND mkca.document_type IS NOT NULL
205: AND mkca.document_header_id IS NOT NULL
206: AND mmt.organization_id = kanban_rec.organization_id

Line 249: FROM mtl_kanban_cards

245: END;
246:
247: SELECT Count(*)
248: INTO l_prev_replenished
249: FROM mtl_kanban_cards
250: WHERE pull_sequence_id = pull_seq_rec.pull_sequence_id
251: AND card_status = 1
252: AND trunc(supply_status) in (3,4,5,6,7,8); -- Wait, Empty, In-process, -In-transit, Wait for consolidation cards
253:

Line 407: FROM mtl_kanban_cards

403: ERRBUF OUT NOCOPY VARCHAR2) IS
404:
405: CURSOR replenish_cards_cur IS
406: SELECT kanban_card_id,kanban_card_number
407: FROM mtl_kanban_cards
408: WHERE pull_sequence_id = p_pull_sequence_id
409: AND supply_status = Trunc(p_supply_status) --use trunc to consider custom status
410: AND card_status = 1 -- Active
411: AND nvl(supplier_id, -1) = Nvl(p_supplier_id, -1)