APPS.INV_KANBAN_LOVS dependencies on MTL_KANBAN_CARDS

Line 23: FROM mtl_kanban_cards

19: p_Kanban_number IN VARCHAR2) IS
20: BEGIN
21: OPEN x_Revs FOR
22: SELECT kanban_card_number,kanban_card_id, 1
23: FROM mtl_kanban_cards
24: WHERE organization_Id = p_Organization_Id AND
25: kanban_card_type = 1 AND
26: card_status = 1 AND
27: inv_KANBAN_PKG.status_check(supply_status, 4) = 2 AND

Line 38: FROM mtl_kanban_cards

34: p_Kanban_number IN VARCHAR2) IS
35: BEGIN
36: OPEN x_Revs FOR
37: SELECT kanban_card_number,kanban_card_id, 1
38: FROM mtl_kanban_cards
39: WHERE organization_Id = p_Organization_Id AND
40: kanban_card_number like (p_Kanban_number)
41: order by kanban_card_number;
42: END GET_KANBAN_NUMBER_FOR_INQ;