689:
690: /*=================================================================*/
691: PROCEDURE get_data_LPN(
692: x_out_tbl IN OUT NOCOPY output_tbl_type,
693: p_lpn_id wms_license_plate_numbers.lpn_id%TYPE,
694: p_revision wms_lpn_contents.revision%TYPE,
695: p_lot_number wms_lpn_contents.lot_number%TYPE,
696: p_serial_number wms_lpn_contents.serial_number%TYPE,
697: p_inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
733: NVL(lpn_wlc.serial_number, p_serial_number) serial_number,
734: decode(p_serial_number, NULL, lpn_wlc.quantity,
735: decode(lpn_wlc.serial_summary_entry, 1, 1, lpn_wlc.quantity)) quantity,
736: lpn_wlc.uom_code
737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
734: decode(p_serial_number, NULL, lpn_wlc.quantity,
735: decode(lpn_wlc.serial_summary_entry, 1, 1, lpn_wlc.quantity)) quantity,
736: lpn_wlc.uom_code
737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
742: wms_lpn_contents lpn_wlc