[Home] [Help]
3479: --Bug#3009495 Get the lot number for the delivered item
3480: CURSOR get_rcv_lot_number(v_shipment_line_id IN NUMBER) IS
3481: SELECT lot_num
3482: , primary_quantity
3483: FROM rcv_lot_transactions
3484: WHERE shipment_line_id = v_shipment_line_id;
3485:
3486: -- Bug 5611560
3487: CURSOR get_rcv_txn_lot_number(v_shipment_line_id IN NUMBER, v_transaction_id IN NUMBER) IS
3486: -- Bug 5611560
3487: CURSOR get_rcv_txn_lot_number(v_shipment_line_id IN NUMBER, v_transaction_id IN NUMBER) IS
3488: SELECT lot_num
3489: , primary_quantity
3490: FROM rcv_lot_transactions
3491: WHERE shipment_line_id = v_shipment_line_id
3492: AND transaction_id = v_transaction_id;
3493:
3494: CURSOR get_rcv_transaction_asn(v_transaction_id IN NUMBER) IS
4480:
4481: END IF; --get_rcv_transaction_rec.item_revision is NULL
4482:
4483: --Bug#3009495.If item is lot controlled then we will derive the lot number
4484: --from the rcv_lot_transactions.
4485: get_rcv_lot_number_rec.lot_num := NULL;
4486: --IF get_shipment_lines%FOUND THEN
4487:
4488: --Bug 7559682 Error performing deliver transaction for Direct Items in EAM workorder
4775: END IF; --get_rcv_transaction_asn_rec.item_revision is NULL
4776:
4777:
4778: --Bug#3009495.If item is lot controlled then we will derive the lot number
4779: --from the rcv_lot_transactions.
4780: get_rcv_lot_number_rec.lot_num := NULL;
4781: --IF get_shipment_lines%FOUND THEN
4782:
4783: --Bug 7559682 Error performing deliver transaction for Direct Items in EAM workorder
4989: END IF; --get_rcv_txn_req_rec.item_revision is NULL
4990:
4991:
4992: --Bug#3009495.If item is lot controlled then we will derive the lot number
4993: --from the rcv_lot_transactions.
4994: get_rcv_lot_number_rec.lot_num := NULL;
4995: --IF get_shipment_lines%FOUND THEN
4996:
4997: --Bug 7559682 Error performing deliver transaction for Direct Items in EAM workorder