BACKUP DUMMY FORM RECEIVE GOODS

SELECT f_get_product_code(A.product_id) AS product_code, f_get_product_name(A.product_id) AS product_name,
           COALESCE(B.serial_number, ' ') AS serial_number, COALESCE(B.product_expired_date, '20161010') AS expired_date,
           COALESCE(B.product_year_made, ' ') AS year_made, COALESCE(B.qty_rcv_po, A.qty_rcv_po) AS qty_po,
           f_get_uom_name(A.po_uom_id) AS uom_po, COALESCE(B.qty_rcv_int, A.qty_rcv_int) AS qty_receive,
           f_get_uom_name(A.base_uom_id) AS uom_receive,  C.remark, C.gross_price_po, C.discount_percentage, C.gross_item_amount,
           C.nett_item_amount
    FROM pu_receive_goods_item A
    LEFT OUTER JOIN pu_receive_goods_product B ON A.receive_goods_item_id = B.receive_goods_item_id
    INNER JOIN pu_po_item C ON A.ref_id = C.po_item_id
    WHERE A.receive_goods_id = 21
    ORDER BY A.line_no;