[Home] [Help]
190: p_lot_location_id IN NUMBER ,
191: p_lot_quantity IN NUMBER,
192: p_replenish_quantity IN NUMBER)IS
193:
194: recinfo mtl_kanban_cards%ROWTYPE;
195: from_supply_status NUMBER;
196: v_supply_val NUMBER;
197: l_return_status VARCHAR2(1);
198: BEGIN
197: l_return_status VARCHAR2(1);
198: BEGIN
199: SELECT *
200: INTO recinfo
201: FROM mtl_kanban_cards
202: WHERE kanban_card_number = p_kanban_card_number
203: AND organization_id = p_org_id;
204:
205: -- Is kanban_card_number unique?
360: , x_wip_line
361: , x_supplier_name
362: , supplier_site_id
363: , x_item_id
364: FROM mtl_kanban_cards_v mkcv, mtl_system_items_vl msiv
365: WHERE mkcv.kanban_card_number = p_kanban_card_number
366: AND mkcv.organization_id = p_org_id
367: AND mkcv.inventory_item_id = msiv.inventory_item_id
368: AND mkcv.organization_id = msiv.organization_id;
526: , wl.line_code
527: , pv_act.vendor_name vendor_last_activity
528: , pvsa_act.vendor_site_code vendor_site_last_activity
529: , wl_act.line_code
530: FROM mtl_kanban_cards mkc
531: , mtl_system_items_vl msiv
532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
688: , mkc.card_status
689: , mkc.supply_status
690: , status_check(mkc.supply_status, 4) status_check
691: , ml.meaning supply_status_meaning
692: FROM mtl_kanban_cards mkc
693: , mfg_lookups ml
694: WHERE mkc.organization_id = p_organization_id
695: AND mkc.kanban_card_number = p_kanban_number
696: AND ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
753: , m.reference_type_code
754: , m.line_status
755: , (NVL(quantity_delivered, 0)- m.quantity) qty_diff
756: FROM mtl_txn_request_lines m
757: , mtl_kanban_cards k
758: WHERE m.reference_id = k.kanban_card_id
759: AND m.organization_id = p_organization_id
760: AND k.kanban_card_number = p_kanban_number
761: ORDER BY m.line_id desc)