APPS.GMO_SWORKBENCH_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 634: l_get_revision mtl_onhand_quantities%ROWTYPE;

630: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
631: --Bug#4604943
632: invalid_mtl_for_rsrv EXCEPTION;
633: create_resvn_err EXCEPTION;
634: l_get_revision mtl_onhand_quantities%ROWTYPE;
635: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
636: IS
637: SELECT *
638: FROM mtl_onhand_quantities

Line 638: FROM mtl_onhand_quantities

634: l_get_revision mtl_onhand_quantities%ROWTYPE;
635: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
636: IS
637: SELECT *
638: FROM mtl_onhand_quantities
639: WHERE inventory_item_id = v_inventory_item_id
640: AND organization_id = v_org_id
641: AND subinventory_code = v_subinv
642: AND ((v_lot IS NULL AND lot_number is null) or (lot_number = v_lot))

Line 887: l_get_revision mtl_onhand_quantities%ROWTYPE;

883: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
884: l_serial_number inv_reservation_global.serial_number_tbl_type;
885: update_resvn_error EXCEPTION;
886: query_resvn_error EXCEPTION;
887: l_get_revision mtl_onhand_quantities%ROWTYPE;
888: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
889: IS
890: SELECT *
891: FROM mtl_onhand_quantities

Line 891: FROM mtl_onhand_quantities

887: l_get_revision mtl_onhand_quantities%ROWTYPE;
888: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)
889: IS
890: SELECT *
891: FROM mtl_onhand_quantities
892: WHERE inventory_item_id = v_inventory_item_id
893: AND organization_id = v_org_id
894: AND subinventory_code = v_subinv
895: AND ((v_lot IS NULL AND lot_number is null) or (lot_number = v_lot))