eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT10 dependencies on WMS_LPN_CONTENTS

Line 694: p_revision wms_lpn_contents.revision%TYPE,

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
698: )IS

Line 695: p_lot_number wms_lpn_contents.lot_number%TYPE,

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
698: )IS
699:

Line 696: p_serial_number wms_lpn_contents.serial_number%TYPE,

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
698: )IS
699:
700: CURSOR lpn_curs IS

Line 697: p_inventory_item_id wms_lpn_contents.inventory_item_id%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
698: )IS
699:
700: CURSOR lpn_curs IS
701: SELECT

Line 742: wms_lpn_contents lpn_wlc

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
743: WHERE lpn.lpn_id = p_lpn_id
744: AND lpn.parent_lpn_id = lpn_pLpn.lpn_id(+)
745: AND lpn_wlc.parent_lpn_id(+) = p_lpn_id
746: AND nvl(lpn_wlc.revision, '$$$') = nvl(p_revision, nvl(lpn_wlc.revision, '$$$'))