APPS.GMO_SWORKBENCH_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 520: l_get_revision mtl_onhand_quantities%ROWTYPE;

516: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
517: --Bug#4604943
518: invalid_mtl_for_rsrv EXCEPTION;
519: create_resvn_err EXCEPTION;
520: l_get_revision mtl_onhand_quantities%ROWTYPE;
521: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
522: IS
523: SELECT *
524: FROM mtl_onhand_quantities

Line 524: FROM mtl_onhand_quantities

520: l_get_revision mtl_onhand_quantities%ROWTYPE;
521: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
522: IS
523: SELECT *
524: FROM mtl_onhand_quantities
525: WHERE inventory_item_id = v_inventory_item_id
526: AND organization_id = v_org_id
527: AND subinventory_code = v_subinv
528: AND ((v_lot IS NULL AND lot_number is null) or (lot_number = v_lot))

Line 771: l_get_revision mtl_onhand_quantities%ROWTYPE;

767: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
768: l_serial_number inv_reservation_global.serial_number_tbl_type;
769: update_resvn_error EXCEPTION;
770: query_resvn_error EXCEPTION;
771: l_get_revision mtl_onhand_quantities%ROWTYPE;
772: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
773: IS
774: SELECT *
775: FROM mtl_onhand_quantities

Line 775: FROM mtl_onhand_quantities

771: l_get_revision mtl_onhand_quantities%ROWTYPE;
772: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
773: IS
774: SELECT *
775: FROM mtl_onhand_quantities
776: WHERE inventory_item_id = v_inventory_item_id
777: AND organization_id = v_org_id
778: AND subinventory_code = v_subinv
779: AND ((v_lot IS NULL AND lot_number is null) or (lot_number = v_lot))