[Home] [Help]
200: p_lot_location_id IN NUMBER ,
201: p_lot_quantity IN NUMBER,
202: p_replenish_quantity IN NUMBER)IS
203:
204: recinfo mtl_kanban_cards%ROWTYPE;
205: from_supply_status NUMBER;
206: v_supply_val NUMBER;
207: l_return_status VARCHAR2(1);
208: BEGIN
207: l_return_status VARCHAR2(1);
208: BEGIN
209: SELECT *
210: INTO recinfo
211: FROM mtl_kanban_cards
212: WHERE kanban_card_number = p_kanban_card_number
213: AND organization_id = p_org_id;
214:
215: -- Is kanban_card_number unique?
371: , x_wip_line
372: , x_supplier_name
373: , supplier_site_id
374: , x_item_id
375: FROM mtl_kanban_cards_v mkcv, mtl_system_items_vl msiv
376: WHERE mkcv.kanban_card_number = p_kanban_card_number
377: AND mkcv.organization_id = p_org_id
378: AND mkcv.inventory_item_id = msiv.inventory_item_id
379: AND mkcv.organization_id = msiv.organization_id;
537: , wl.line_code
538: , pv_act.vendor_name vendor_last_activity
539: , pvsa_act.vendor_site_code vendor_site_last_activity
540: , wl_act.line_code
541: FROM mtl_kanban_cards mkc
542: , mtl_system_items_vl msiv
543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
699: , mkc.card_status
700: , mkc.supply_status
701: , status_check(mkc.supply_status, 4) status_check
702: , ml.meaning supply_status_meaning
703: FROM mtl_kanban_cards mkc
704: , mfg_lookups ml
705: WHERE mkc.organization_id = p_organization_id
706: AND mkc.kanban_card_number = p_kanban_number
707: AND ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
764: , m.reference_type_code
765: , m.line_status
766: , (NVL(quantity_delivered, 0)- m.quantity) qty_diff
767: FROM mtl_txn_request_lines m
768: , mtl_kanban_cards k
769: WHERE m.reference_id = k.kanban_card_id
770: AND m.organization_id = p_organization_id
771: AND k.kanban_card_number = p_kanban_number
772: ORDER BY m.line_id desc)