692: , x_supply_status_meaning OUT NOCOPY VARCHAR2
693: , p_organization_id IN NUMBER
694: , p_kanban_number IN VARCHAR2) IS
695: l_proc CONSTANT VARCHAR2(30) := 'GET_KANBAN_DETAILS';
696: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
697: CURSOR c_kb_details IS
698: SELECT mkc.kanban_card_type
699: , mkc.card_status
700: , mkc.supply_status
756: , x_mo_line_qty_diff OUT NOCOPY NUMBER
757: , p_organization_id IN NUMBER
758: , p_kanban_number IN VARCHAR2) IS
759: l_proc CONSTANT VARCHAR2(30) := 'GET_KANBAN_MO_DETAILS';
760: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
761: -- Bug 4574518, when the kanban card is replenished more than once, there will be more records and the latest record should be used
762: CURSOR c_kb_mo_details IS
763: SELECT * FROM (SELECT m.line_id
764: , m.reference_type_code